SQL Server High-version data This is restored to the lower version method

Recently encountered a problem:

You want to restore SQL Server high-backup data to a lower version of SQL Server, but it is not possible to directly restore the database in SQL Server, so after a series of consulting to summarize the available methods.

First of all, you have to have a high version of SQL Server you are going to operate on your computer, or you can connect to a database with a high version of SQL Server (which allows you to copy data later).

The second step is to open the database in the high-version database that you need to back up, and delete the logins or users that are associated with the database you backed up. Right-click Database, Task--build script. In the "Select objects" step of the build script, select "Script options for writing the entire database and all database objects." Set the Write use database script and schema qualified object name option to False in the advanced options in the Set scripting options for the build script and select Server Edition script as the version of your lower version of the database. Generates a script.

In the third step, create a new database in your lower version of the database (name casually) and open the SQL script. Delete all operations on the original database name in the script, dividing the database from the first alter operation into two parts, and performing the first part of the table operation on the new database.

Fourth, right-click New Database-----import data, set the data source to a higher version of the database, and set the target to the current database. Then choose to copy one or more charts. Select all the data tables, and then, in edit mappings, choose Enable identity insertion. Import data

The fifth step, and then the second part of the previous split SQL script, the database is indexed!

Ok. The recovery to this high-version SQL Server database was successful in the low-version SQL Server

SQL Server High-version data This is restored to the lower version method