How to migrate sql scripts from 08 to 05

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » How to migrate sql scripts from 08 to 05

How to migrate sql scripts from 08 to 05

Rate Topic

Display Mode

Topic Options

Author

Message

@ry@n

Posted Tuesday, December 25, 2012 11:04 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 3:26 AM
Points: 16, Visits: 61

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

Joie Andrew

Posted Thursday, December 27, 2012 5:27 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:04 PM
Points: 555, Visits: 1,036

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 »

Permissions