SQL Server Notes--How do I downgrade a SQL Server database from a higher version to a lower version?

Method One: Using the graphical operation (GUI), open ssms (SQL Server Management Studio) The first step: Right-click the database you want to downgrade, press Select:

Step Two: In the dialog box, in advanced, set as follows.

Step three: Save the script and run the script in the lower version of SQL Server.

Open the low-version SQL Server database, connect to the database, and double-click the script to run. or drag the script to the query parser interface of the database (paste the script code in the new query), and then click Run.

Fourth step: Import data from a high version to a database created with a script from a later version using tasks → import data in a higher version of SQL Server .

Note: Select the. bak file from the higher version of the database and import it into the lower version. (After the execution of the script, the lower version of the database should be created an empty database, no data in the database, this step is to import data into the database)

OK, complete the operation.

But note here, if from 2008 directly down to 2000, the span is very large, and 2000~2005 is a big leap, many many compatibility issues, so do not rule out in the generation of scripts and data will be error (and the likelihood is larger!). If there is, then you have to manually remove those errors, and then write down, continue to run the wrong, and finally manually create the error.

SQL Server Notes--How do I downgrade a SQL Server database from a higher version to a lower version?