How to Downgrade SQL Server Database
Jan 2, 2011
In my previous article I had explained the reasons Why an SQL Server Database from a higher version cannot be restored onto a lower version? However, in this article we will go through the steps to downgrade an SQL Server 2008 R2 database to SQL Server 2008 using SQL Server Import and Export Wizard which internally leverages SQL Server Integration Services. The steps mentioned in this article are also applicable to downgrade database from SQL Server 2008 R2 to SQL Server 2005 or SQL Server 2000.
1. Connect to SQL Server Database Instance Using SQL Server Management Studio and then expand Databases Node.
2. Right click AdventureWorksLT2008R2 database, expand Tasks and choose Export Data option from the drop down menu to open up SQL Server Import and Export Wizard as shown in the image below.
Highly Recommended:- You can avoid this isuue in future by using a Free SQL Server Monitoring Tool "Database Performance Analyser".
3. In SQL Server Import and Export Wizard click Next as shown in the image below to continue with the wizard.
Click on Next Page to continue reading rest of the article…
Continue Free Learning...