Post reply

V7 to 2000 Upgrade Questions

  • April 19, 2002 at 4:57 am

    #101126

    Hya,

    I am due to upgrade a v7 db which hosts a datawarehouse. Generally a bunch of DTS packages. This machine needs upgrading to SQL Server 2000. Has anyone got any horror stories about DTS and a v7 to 2000 upgrade, or is it pretty much ok?? I`m doing it on a test machine first though.

    Andy.

  • April 19, 2002 at 5:19 am

    #427476

    I didnt have many packages but the ones I did were fine. The upgrade in general was painless. Remember to run sp_updatestats after the upgrade on each db to get the stats current in SQL2K format.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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