Find the good way to upgrade from SQL 2000 to 2008

  • Dear all

    I have a DB SQL 2000 with default name Instance long time before. Now I want to upgrade to SQL 2008. But there are so many Winform Applications of customers that have connection string in config file and it's difficult to change these config files, that's why I want to use Default Instance name also in SQL 2008.

    My steps are:

    1) Stop SQL 2000 with Default Name Instance

    2) Install SQL 2008 with Default Name Instance

    3) Mount data files of SQL 2000 to SQL 2008

    But it takes much downtime in step 2. So is there any good way to reduce downtime, for example install SQL 2008 with any instance name before stop SQL 2000 then change to Default Name Instance later ?

    Thanks

  • This is why doing side by side install is often the best choice.

    Make a new server, backup / restore and test the new system through and through.

    Once you're done restore the lastest version on the new server and rename after taking down the hold one.

    If yo have a screw up you can just restart the old server and you have minimum downtime.

  • Your comment is good but what a pity I don't have second server to exchange 😎

  • thang_ngo_2002 (8/23/2011)


    1) Stop SQL 2000 with Default Name Instance

    2) Install SQL 2008 with Default Name Instance

    3) Mount data files of SQL 2000 to SQL 2008

    You wont be able to do this. Regardless of version, you can only have one default instance. You will have to uninstall SQL 2000 or do an inplace upgrade. Neither is ideal, but in certain circumstances its the only way.

    Ensure you've got all your backups, logins scripted, jobs scripted etc etc.

  • Tell them about the risk. This is something real easy to do with vms.

    If ANYTHING goes wrong, and it DOES. Then you're screwed with in place upgrade.

    What's worst? Buying an extra srever ahead of time or losing 1-2 days of production?

    Do the maths, servers can look very cheap in that comparaison. Mostly because you still have the "old" server to do something else (exchange, file server, backups... etc).

  • MysteryJimbo (8/24/2011)


    thang_ngo_2002 (8/23/2011)


    1) Stop SQL 2000 with Default Name Instance

    2) Install SQL 2008 with Default Name Instance

    3) Mount data files of SQL 2000 to SQL 2008

    You wont be able to do this. Regardless of version, you can only have one default instance. You will have to uninstall SQL 2000 or do an inplace upgrade. Neither is ideal, but in certain circumstances its the only way.

    Ensure you've got all your backups, logins scripted, jobs scripted etc etc.

    In case I stop SQL 2000 and disable this Windows service, so I think no need to uninstall SQL 2000. Is it correct ?

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

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