Thread: Restore Database in Older Versions of MS SQL

If you backup your database from a newer version, and then try to restore it in a older version of a MS SQL database you will get error. MS SQL simply doesnt seem to allow it.

To overcome this you could take an alternative like this:

• Open SQL Server Management Studio
• Click to select your source Database
• Right click on your source database
• Select Tasks>Generate Scripts.
• Select 'Script entire database and all database objects', press 'Next'
• Select 'Save to File' and click on the 'Advanced' button
• Select 'Script for Server Version' and select the version you want: 200/2005/2008
• Select 'Type of data to Script' and select Schema/Data/both
• Click 'OK',Next and follow the steps.
• Copy the file from the generated file.
• Log onto your SQL Management Studio in your target maching and open the copied .sql file.
• There may also be issues with the order that the .SQL file inserts the data into the target database and if there are FK constraints in place, this could be an issue.... simply re-order the insert lists.
• Once the .sql file is organised, parse it [just to sure], and then execute.

you have posted the best topic and you have given the good solution......
Thank you.........

It is a nice and very useful posting,now I have a clear idea about MY SQL.