Database Discussion - Transfer SQL Database

Print Page | Close Window

Transfer SQL Database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2822
Printed Date: 29 March 2026 at 11:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Transfer SQL Database

Posted By: Bliss
Subject: Transfer SQL Database
Date Posted: 18 May 2003 at 4:16pm

Does anyone know if you can transfer a SQL database from one host to another without damaging the database?

Replies:

Posted By: Bunce
Date Posted: 18 May 2003 at 5:01pm

Yep. Depends on how much control you have over your host though.

If you have access to DTS then this is probably the easiest method.

If you Right-Click on your database in Enterprise Manager and select Export Data, you will see the DTS wizard where you can copy data between databases.

If you don't have this power, then you might need to do it through script. If you search google there may be some ASP scripts to do this.

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: Bluefrog
Date Posted: 25 May 2003 at 11:08am

Bunce is right about control... but the best way is to get into the enterprise manager, "detach" the database, transfer the MDF and the LDF files to the new host, then "attach" the new database. You may need to make a few phone calls for that. You may also need to redo permissions in a few places. I don't know what your DB looks like, but that should be enough to get you on the right track. i.e. Detach it from the one place, and then Attach it in the new place.

[ oops - edited for silly typo - host/hose ]