Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version
Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000?
A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the documented process in BOL. How about downgrade the same database from SQL 2005 to SQL 2000 if there is a problem with your application that was found after the upgrade or could be any other reason.
Here are the steps to follow:
- Create a blank database in SQL Server 2000 with similar sort & collation settings as compared to upgraded database in SQL 2005.
- In SQL 2005 Management Console Studio , from Database -> tasks -> Generate Script -> select Database ->Script for Server Version -> Change it from SQL Server 2005 to SQL Server 2000.
- Follow the process as per the Script wizard.
- Execute that script into SQL Query Analyzer version 2000 for that selected database where you want to move it.
- Now you should be able to get whole database table creation and whole relationship which was made into SQL Server 2005.
- Next step is to use BCP or DTS to import data from SQL 2005 database.