This tip is on loading MS MSQ 2000 old databases. We will post a later tip on later MS SQL databases. Here you go — free on us — compliments of http://www.sozohosting.com/ and also compliments of http://www.biznesstechnologies.com/ :

How do I load an MS SQL 2000 Database Using MS 2000 Enterprise Manager?

Open MS 2000 Enterprise Manager and click on the database you want as the source to copy from. Right click on that database and choose the All Tasks menu then the Import Data menu option under that All Tasks menu. This will open up an initial dialog box for you just to click next which will take you to the SOURCE Dialog box. In Source Dialog box leave the top Data Source drop down on “Microsoft OLE DE Provider for SQL Server”.

Change the server dropdown to the source server or source IP. Enter your SQL Server authentication and choose the correct database. Click the next button to open up the DESTINATION dialog box. Leave the Data Source as “Microsoft OLE DE Provider for SQL Server” and change the server dropdown to the destination server or source IP. Enter your SQL Server authentication and choose the correct database.

DOUBLE CHECK YOU HAVE THE RIGHT DATABASE. Click the next button to open up the Table/Copy Dialog box. Choose the bottom selection “Copy ojects and Data Between SQL Server Databases”and click Next. Click on the OPTIONS button and another dialog box will open. UNCHECK the top 3 checkboxes in the top Security Options section and click OK to close this second dialog box. On the remaining dialog box click Next.

To run it immediately chick on the Next button and then finally click on the Finish button to start the import. You will get a status bar of the completion of your import. Failures are typically due to permissions not being granted to you.

Categories: Uncategorized ,Web Hosting ,Web Hosting and Database Tips


Leave a Reply

You must be logged in to post a comment.