Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, December 25, 2012 11:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


Hi,

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 fine...is there any other way to get is done..Your comments plz





Warm Regards,
Anil K
MCTS

Post #1400146
Posted Thursday, December 27, 2012 5:27 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 4:02 AM
Points: 709, Visits: 1,422
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