Post reply

discontinued features between sql 2000 and sql 2008

  • August 6, 2009 at 3:40 pm

    #208359

    Hello, we are in the process of planning SQL 2000 upgrade to SQL 2008 64-bit.

    It will be a clean install.

    Would anybody know where to find a list of any T-SQL that is discontinued between SQL 2000 and SQL 2008.

    Does anybody know if SQL 2008 has the ability to run the DTS Package Emulator so DTS packages can work as in SQL 2000 as normal while they are changed over in time?

    Thanks

  • August 7, 2009 at 6:44 am

    #1035942

    You can get the list of deprecated items from a search on MSDN. You can run DTS inside SSIS, but the behavior is very inconsistent. You'll need to do a lot of testing. I'd suggest looking into DTSXchange. It's a conversion package from PragmaticWorks. It'll save you a lot of headaches.

    "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