How can I move my
SQL database from my old provider?
To import your SQL database from
your previous provider you need to use Microsoft SQL Enterprise
Manager. This is available in the trial version of SQL which does
not expire. To download Enterprise Manager click the download link
above. To see how to install it, find Article 66. To set it up, find
Article 137. After you have installed and setup the software, follow
the directions below:
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, choose "Use SQL Server Authentication," type in
your old username and password, choose your database from the
"Database" field, click "Next"
4. In the "Server" field, type in your new SQL server's
address, choose "Use SQL Server Authentication," type in
your current username and password, choose your database from the
"Database" field, click "Next"
5. Choose "Copy objects…" (third option), click
"Next"
6. Leave next window as is, click "Next"
7. Leave next window as is, click "Next"
8. Click "Finish" and let the transfer take place.
|