kcwallace Posted December 7, 2006 Posted December 7, 2006 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. Quote Go Beavs!!!
Administrators PlausiblyDamp Posted December 7, 2006 Administrators Posted December 7, 2006 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. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.