Copying DB from SQL Server 2000 to MSDE (Personal Edition)

[tibs]

Our current production database is on SQL Server 2000, I have MSDE (Personal Edition) on a laptop. I need to copy this database onto the laptop for testing and development. Periodically (possibly once per week) I will need to update the database on the laptop to ensure I'm working with the latest data. There will be no need to transfer any data back to the server.

Whats the best way to do this?

 

[fluteplr]

Have you tried just doing a backup and restore?

 

[tlbroadbent]

I agree with Fluteplr. Backup up the development database. This should already occur as part of regular maintenence. Then restore the backup to the database on the laptop.

I recommend reading the articles at the following links which provide solutions for problems that can occur when copying databases to another computer.

HOW TO: Resolve Permission Issues When You Move a Database Between Servers That Are Running SQL Server

http://support.microsoft.com/default.aspx?kbid=240872

http://support.microsoft.com/default.aspx?kbid=274188

PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete

http://support.microsoft.com/default.aspx?kbid=304692

INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm