Post reply

Install SQL 2005 and Uninstall SQL 2000

  • August 7, 2008 at 12:08 pm

    #126912

    I have SQL 2000 with 10 DB with NO DTS, I want to install SQL 2005.

    Shall I take a backup and Uninstall SQL 2000 and Install 2005.

    Or Shall I install SQL 2005 and then uninstall SQL 2000?

    Or just leave both the instances and disbaled SQL 2000 services?

  • August 7, 2008 at 12:22 pm

    #854682

    If you have the space and you don't care if you have a named instance, you should leave the SQL 2000 instance and install SQL 2005 as a named instance. When you're confident that you don't need SQL 2000 anymore you can delete the instance.

    I've done this several times and it has worked well. It leaves you with the ability to access the SQL 2000 instance if you realize that you forgot to migrate something and you can migrate the databases one at a time. You have to be careful to make sure your applications point to the correct instance, then just make the old database Read-Only.

    Greg

  • August 7, 2008 at 12:25 pm

    #854684

    Thanks,

    So Install 2005 and later Uninstall 2000 won't screw registry?

  • August 7, 2008 at 12:37 pm

    #854694

    It shouldn't. We did this in the dev environment, but when we migrated in production, we actually used new servers for the 2005 instance.

  • August 7, 2008 at 12:55 pm

    #854706

    Thanks I will leave it rather then delete 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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