Different versions of SQL Server database backup restore problems, not version version of the database import from high to low in the data (including the entire database and backup copy. Bak reduction),

This paper introduces a database scripts reduction, is a good way to solve this problem,



One, to generate the script file

1. Right-click to choose need to backup of the database, select the task - generation script,

2. Click next,

3. Arriving at page choose to save the path and filename

4. Click the advanced - to write a script data type - select "architecture and data,"

5. Click ok after generation script files,

Second, restore script

1. Open the database to create a new database, the database name and to restore the database name should agree,

2. Click on "file", "open file", open the script file export,

3. In the new query box, and click "perform" or "run" button, run after the completion of the can see the table in the database have reduction, (note: if no data is only form in the generated script file no number 1 to write the script according to the type of "architecture and data" instead,)

CodePudding user response:

OK!!!!!!!!!!