Share via

Upgrade SQL Server from 2000 to 2012/2014

  • Article

Problem:
we cannot upgrade a SQL Server 2000 instance or database to SQL Server 2012 directly.

For a side-by-side upgrade, first restore the SQL Server 2000 databases to SQL Server 2005, 2008,
or 2008 R2,and then restore the resulting database to SQL Server 2012.

**Solution: **

Sql server up gradation from 2000 to 2012/2014

steps: 

Carry out up gradation in Development environment

 

1.Upgrade sql server 2000 with compatibility level 80  to sql server 2008 (compatibility level 100)

 

                                I.  Restore a copy of sql server 2000 database in sql server 2008 instance.

                              II. Set the compatibility level to 100.

                            III. Then run the upgrade advisor 2008 , reports will be generated.

                            IV.From the  report incorporate all changes to the databases of sql server 2008.

2. Now Upgrade sql server 2008  database with compatibility level 100 to  sql server 2012/2014 (compatibility level 110/120)

                                I. Restore a copy of sql server 2008 database in sql server 2012 instance.

                              II. Set the compatibility level to 110/120.

                            III. Then run the upgrade advisor 2012/2014 , reports will be generated.

                            IV. From the  report incorporate all changes to the databases of sql server 2012.