Questions

Code Changes while migrating sql server 2000 to 2005

Tags:
+
0 Votes
Locked

Code Changes while migrating sql server 2000 to 2005

skurulkar
Can you please let me know what all key changes required in stored procedure / functions while migrating project from 2000 to 2005 instance.

Thanks

Sujay
  • +
    0 Votes
    lalit.k.bhatia

    Use Microsoft SQL Server 2005 Upgrade Advisor tool to check compatibility of your database with 2005.
    It will show areas that need to be changed as part of upgrade

    +
    0 Votes
    chapman.tim

    You shouldn't have to incur any procedure changes to allow the upgrade to 2005. The only changes you will incur is when you try to take advantage of the new features.

  • +
    0 Votes
    lalit.k.bhatia

    Use Microsoft SQL Server 2005 Upgrade Advisor tool to check compatibility of your database with 2005.
    It will show areas that need to be changed as part of upgrade

    +
    0 Votes
    chapman.tim

    You shouldn't have to incur any procedure changes to allow the upgrade to 2005. The only changes you will incur is when you try to take advantage of the new features.