By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,432 Members | 795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,432 IT Pros & Developers. It's quick & easy.

MS SQL database Transfer

P: 2
How can I transfer an online MS SQL Database with all data to a local machine MS SQL server. I am using Import Export Tool provided by MS SQL Enterprise manager but the referential integraity breaks (Primary and secondary key relationship). Thus the Data concurrency is lost and the database becaomes of no us.

Most of our database projects have Stored procs, Views, Triggers and contain data. Sometimes we have to take back up of the running database.

The same problem comes when we try to install an offline database with data online. We have to run the scripts through Query Analyser on the online server to install database tables, procs, triggers etc and then repopulate the database once again.

But if you see mySQL one can import the complete database with all data using phpmyAdmin tool. Most hosts provide this tool so becomes easier.

Though MS SQL has a database restoration option but 90% hosts do not allow you to automatically generate back up and download. You have to request them and then they generate the backup and upload to web server folder for us to download and restore.

Can anyone explain a solution to this daily problem..
Jul 10 '06 #1
Share this Question
Share on Google+
3 Replies


P: 4
axaya

This is the DTS import/export wizard. Have you tried the "Copy objects and data Between SQL Server databases" option ?? This should copy all objects when doing the export. this copied all constraints, indexes...




Hope that helps :-)
Jul 12 '06 #2

P: 2
Any other way. DTS takes huge time and connection fails.
Jul 12 '06 #3

P: 4
How about detaching and attaching the DB, check out the link.

http://support.microsoft.com/kb/224071/
Jul 19 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.