Sometimes you want to script to complete database including the data

If you want to restore a database from SQL2012 to SQL2008 or lower you have to script the compleet database including data.

This because there is no backward compatability between SQL2012 and SQL2008. So database restored and on a SQL 2012-server are not going to be restored on the old production server!

To script the whole database, including data, you will have to choose the advanced scripting options and the in the dropdown of the typeofdatascript choose for scheme and data. Well it's a litle bit hidden but once you know it it can be a timesaver.





Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!