Many times we are asked if it is possible to degrade a SQL Server database from a higher version to a lower one due to the business needs of data migration. However, it looks that Microsoft SQL Server doesn’t support degrading a SQL Server database from a higher version to a lower version by using the Copy Database Wizard or the detach and attach methods.
Yes, degrading a SQL Server database is not supported, but you can use a flexible workaround to resolve this issue. You can use SQL Server Management Studio to first generate scripts for a lower version and then use Data Import/Export Wizard to transfer data. For example, if you want to degrade a SQL Server 2008 database to SQL Server 2005, you can follow the steps below:
1. Open the SQL Server 2008 database in SQL Server Management Studio 2008.
2. Right click the database name in the Object Explorer and select "Tasks Generate Scripts…"
3. In the Script Wizard dialog box, select the database name and check "Script all objects in the select database". Then click "Next".
4. Set the "Script for server version" option as SQL Server 2005.
5. Run the script in SQL Server 2005.
6. Import data from SQL Server 2008 to SQL Server 2005 by using the SQL Server Import and Export Wizard.
Similarly, you can do
View Complete Post