好东西，转过来分享一下，数据库高版本降级到底版本

Introduction

In my previous article I had explained the reasonsWhy 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.

3. In SQL Server Import and Export Wizard click Next as  shown  in the image below to continue with the wizard.


 Read more: http://www.mytechmantra.com/LearnSQLServer/Downgrade_SQL_Server_Database_P1.html#ixzz1tEDdz28i

posted @ 2012-04-27 16:45  sshh  阅读(277)  评论(0)  编辑  收藏  举报