Restore higher version database backup on lower version MS SQL server

Article Details
Article ID: 605
Created On: 02 Aug 2012 07:36 AM

Answer 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:

For ‘types of data to script’ option Select ‘Schema and data

For ‘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.