SQL Server database high version backup restore to low version _mssql

problem Description: high-version SQL backup in low version SQL restore problem (the media cluster is not structurally correct)

Analysis reason: SQL version compatibility issue, SQL Server compatibility level is used for backward compatibility, high version of SQL Backup is incompatible in low version

Workaround:
1, through the manager of the Script Generation Wizard, the other databases, tables, stored procedures, and other objects of the script generation, and then in the lower version of SQL Server execution to build these objects.
2, through Dts/ssis, the data in the table to guide the past.

Here we give a detailed introduction to the 1th development method (sql2008 to sql2005 for example).

1. First, we generate scripts for other databases in sql2008.

2. We click "Next" in the build script interface.

3. In the step of setting scripting options, click Advanced, set the data type of script to be written and script for server development for SQL Server 2005 and architecture and data.

4. Next, "Next" generates our script file.

5. Create other databases with the same name in SQL Server 2005 other databases.
6. Open the script and select the corresponding other database.

7. Analyze and execute the script query.
8. Complete.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.