Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to migrate sql scripts from 08 to 05 Expand / Collapse
Posted Tuesday, December 25, 2012 11:04 PM


Group: General Forum Members
Last Login: Monday, December 23, 2013 5:30 AM
Points: 16, Visits: 63


We have developed some scripts in SQL Server 2008. Now, we need to migrate them to SQL Server 2005.

Should i generate database script (for all its objects by SSMS GUI) after setting the compatibility level to 90.

Is this the right way to do it...will it work there any other way to get is done..Your comments plz

Warm Regards,
Anil K

Post #1400146
Posted Thursday, December 27, 2012 5:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 4:15 PM
Points: 949, Visits: 1,884
How many scripts are you talking about? If it is not too many you can open up the scripts in Management Studio, connect to the SQL 2005 instance and start parsing them using the parse blue check button to see if they pass. Then start working through any issues it shows.

Not sure if there is a more programmatic way of going about it.

Joie Andrew
"Since 1982"
Post #1400574
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse