Post reply

SQL Server 2000 Upgrade to SQL Server 2005

  • February 4, 2008 at 8:30 am

    #182454

    like to ask few questions.

    How we can transfer DTS packages from SQL 2000 to SQL 2005.

    I also want the checklist of any risk or data lose in this Transfer.

    How we can transfer every thing e.g Store procedure, Functions, Views, DTS from SQL 2000 to SQL 2005.

    How we can test that all the databases has been transformed. I mean test plan.

  • February 4, 2008 at 8:54 am

    #774770

    A full backup and restore should work fine for the database, users, stored procs, etc. You can also use the database migration wizard in sql 2005

    The DTS packages you can pull in by opening dts from sql 2005 (under management/legacy in ssms) and use the migration wizard.

  • February 4, 2008 at 8:56 am

    #774773

    If any of the objects fail to copy over using either the dts wizard or the database migration wizard, you will get see errors in the wizard.

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

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