Post reply

Advice to upgrade from SQL Server 2000 To SQL Server 2008 Needed

  • December 22, 2009 at 12:18 am

    #213834

    I am planning to upgrade from SQL Server 2000 to SQL Server 2008

    I have heard that there some differences that applications that uses the database should take into account

    such differences is regarding strings that is being inserted int data base

    in sql server 2000 if the string was bigger than the field the data is truncated

    I have heard and I do not know if it is true that in SQL Server 2008 the database will generate an error.

    First I am looking to verify this is true

    Secons I am Looking for more recomendations of this kind .

    Thanks for any Help

  • December 22, 2009 at 10:20 am

    #1095520

    The link provided gives you some valuable links to Microsoft's upgrade and migration information.

    I strongly suggest the Upgrade Advisor and the System Configuration Checker.

    I have successfully upgraded from SQL Server 2000 to 2008, but the only issues I had experienced were converting DTS packages to SSIS and small issues moving from a 32-bit environment to a 64bit environment.

    I'll post back if I can think of anything else.:-)

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

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