sql 2000 --> sql 2005?

K

kcwallace

Well-known member
Joined
May 27, 2004
Messages
172
Location
Irvine, CA
I have a MS SQL Server 2000 database. That custimers need to access 24/7. I need to migrate that data to a SQL Server 2005 database for testing. What is the best method for accomplishing this?

Should I copy the data files from the current server to the new server, and import the copied 2000 data file?
Can sql 2005 restore a 2000 backup?

Any suggestions shall be greatly appreciated.
 
Either restoring a 2000 backup or copying and then attaching a 2000 db to sql 2005 will work - be aware though that some internal structures (system tables etc.) will be upgraded during either process.
 
Back
Top