Restore higher version database backup on lower version MS SQL server
02 Aug 2012 07:36 AM
Script the database Objects and restore them on the server
To script the database objects you can use Generate Scripts Task.
Generate Scripts Task can be found in MS SQL Server management studio.
RightClick on the database -> Click On Tasks -> Then Click on Generate Scripts…
Run through the wizard.
In the set scripting options tab in the generate scripts wizard click on advanced and select the following options:
types of data to script
’ option Select ‘
Schema and data
Script for version
’ select the required
target MS SQL Server version
Generate the scripts and run the generated scripts on the destination server.
You may have to run the script multile times when you face any error.
Create a new database every time you rerun the script.
Fix the errors that you may face due to order in which
objects are created (or) data is inserted into tables different tables.