Showing posts with label ms. Show all posts
Showing posts with label ms. Show all posts
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.
Read more »
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.
Subscribe to:
Posts (Atom)