How can I move a SQL database from my old host?

To import your SQL database from your previous host, you need to use Microsoft SQL Enterprise Manager. You can download Enterprise Manager from www.microsoft.com. For instructions on how to set it up, view Article #137, How do I connect to a MS SQL Server Database using Enterprise Manager?

After you have installed and setup the software, follow these steps:

1) From the Start Menu, choose "Programs," to "Microsoft SQL Server," to "Import and Export Data."

2) On the new window, click "Next."

3) In the "Server" field, type in your old SQL server's address and choose "Use SQL Server Authentication." Type in your old username and password, choose your database from the "Database" field and click "Next."

4) In the "Server" field, type in your new SQL server's address and choose "Use SQL Server Authentication." Type in your current username and password, choose your database from the "Database" field and click "Next."

5) Choose "Copy objects…" (third option) and click "Next."

6) Leave next window as is and click "Next."

7) Leave next window as is and click "Next"

8) Click "Finish" and let the transfer take place.

Add Feedback