Thank for this piece of information as we are also planning to move some of our SQL Server 2000 database to 2008 R2.
Is there any difference if we move to SQL Server 2012 from SQL Server 2000 data bases Please update
Syed Qazafi Anjum
You will be not able to migrate from SQL 200 to 2012 directly.
SQL Server 2012 supports upgrade from only the following versions: SQL 2005 SP4 or SQL 2008 SP2 or SQL 2008 R2 SP1.
You will have to make the migration in two steps:
- Step 1 : Make a first migration from SQL 2000 to SQL 2008 for instance
- Step 2 : Make a second migration from SQL Server 2008 to 2012.
I invite you to read the following bol : Supported Version and Edition Upgrades (msdn.microsoft.com/.../ms143393.aspx )
Migration SQL Server 2000 to SQL Server 2012