Trending SQL Server Tips

How to Downgrade SQL Server Database

By: Editor
Jan 2, 2011

Page: 1/4


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.

"This article has a total of 4 pages including this page. Click the links below to open all 4 pages in a seperate window to learn How to Downgrade SQL Server Database. Page 1, Page 2, Page 3, Page 4"

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.

Open SQL Server 2008 Import Export Wizard

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.

SQL Server 2008 Import Export Wizard   

Click on Next Page to continue reading rest of the article…

Next Page..

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article

Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."