Post reply

How to migrate sql scripts from 08 to 05

  • December 25, 2012 at 11:04 pm

    #393837

    [font="Times New Roman"]

    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

    [/font]

  • December 27, 2012 at 5:27 am

    #1571827

    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"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply