Take the 2-minute tour ×

Can anyone please let me know steps to merge databases from SQL Server 2000 to a database running on SQL Server 2008?

How the data of SQL Server 2000 system databases (master, tempdb, model, msdb) will be merged in system databases of SQL Server 2008

share|improve this question
You typically don't merge any of the system databases - just your own –  marc_s Aug 10 '11 at 16:00
The system documentation will clearly tell you the steps to upgrade a database. If you have a any questions after you read this, then come back and ask. –  HLGEM Aug 10 '11 at 18:22

1 Answer 1

Microsoft has a whole white paper dedicated to the topic.

share|improve this answer
Marc, I agree but there are plenty of tables in the 2000 system databases...is there any tool to move them –  Ami Aug 10 '11 at 16:11

Your Answer


