Post reply

Need a checklist to migrate SQL Server 2000 SProc''s to SQL Server 2005

  • September 5, 2007 at 10:54 pm

    #180939

    Hi,

    Can anyone provide me a checklist to verify while migrating the Stored procedures from SQL server 2000 to SQL server 2005.

    Thanks & Regards,

    Ramani

  • September 6, 2007 at 2:06 am

    #731729

    The very first thing probably is to run SQL Server 2005 Upgrade Advisor. It detects a lot of things such as using new reserved keywords (e.g. pivot).

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • September 6, 2007 at 2:43 am

    #731740

    Hi Andras,

    Thanks alot for your reply.

    I will try to run it and find out what are all the changes I need to made.

    Thanks,

    Ramani

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

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