Post reply

Upgradation - Migration

  • January 13, 2008 at 3:39 am

    #185521

    Hi ,

    We are planning to migrate our application to SQL Server 2005.

    Initially the code was implemented in SQL Server 6.5 then migrated to SQL 2000 without doing any upgradation in SPs.

    Now I want to convert all the SPs to SQL Server 2005.

    Here the problem is mostly

    -> JOIN operators are used *= and =*. It works well in SQL 2000. But it wont support in SQL 2005.

    -> Also some sql functions works different in SQL 6.5 and SQL 2005.

    EX: REPLICATE (123,0) returns NULL in SQL 6.5, but in sql 2005 it returns empty string.

    So I want to do all this manual migration. Can someone please help me apart from these changes what are all the code/ function I want to migrate. Is there any tool/easy way to reduce the manual effort?

    Any help on this much appreciated.

    Thanks,

    Balaji L

  • January 13, 2008 at 4:27 am

    #767475

    The one piece of advice I can give you is to get the Microsoft Upgrade Advisor. This will identify the places where you need work in your existing 2000 database.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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