frontserve.com web site







 
GENERAL HELP

 
CONTROL PANEL

 
SHARED SSL

 
EMAIL HELP

 
UPLOADING

 
ASPMAIL

 
COLDFUSION

 
SQL SERVER 2000

 
MEDIAHOUSE STATS

 
CONTACT SUPPORT






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.




TOP^    

frontserve.com
WEB SITE HOSTING DONE RIGHT