Sqlserver database high-version backup to a low version method, sqlserver Database

Sqlserver database high-version backup to a low version method, sqlserver Database

Problem description:Restored SQL statements in earlier versions (incorrect media cluster structure)

Cause: SQL version compatibility issues. The SQL server compatibility level is used for backward compatibility. SQL backup of a higher version is not compatible with a lower version.

Solution:
1. Use the script generation wizard in the Manager to generate scripts for other databases, tables, stored procedures, and other objects, and then execute these scripts under the SQL server of earlier versions ..
2. Data in the table is imported through dts/ssis.

Here we will introduce in detail the 1st development methods (taking restoring other databases of sql2008 to sql2005 as an example ).

1. First, we generate scripts corresponding to other databases in sql2008.

2. Click "Next" on the script generation page ".

3. in this step, click "advanced ", set "Data Type of the script to be written" and "develop scripts for server" to "SQL server 2005" and "Architecture and Data ".

 

4. "Next" and "Next" generate our script file.

 

5. Create a database with the same name as other databases in SQL server 2005.
6. Open the script and select another database.

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

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.