Saturday, February 28, 2015

How to migrate upgrade update MS SQL Server 2000 database to SQL Server 2012

I was looking for a way / description how to upgrade an existing SQL Server 2000 database to SQL Server 2012.

How i fixed it:
SQL Server 2000 database has to be upgraded to 2005/2008 first.

If found the right hints how to do it in the SQL Server Forum here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ab5617e-0644-4434-96af-ebc04ba89f75/upgrading-from-sql-2000-to-2012-how

The procedure is described well in this document:
http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf

It says (page 241), that i have to first upgrade the database from 2000 to 2005/2008 and then to 2012.



 
for details click below

No comments:

Post a Comment