Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: upgrade \ migration question sql server 2000 to 2005

    We have A SQL Server 2000 Server with Several Instances and a seperate SQL Server 2005 Server built out with the same instances and I have been migrated databases from 2000 to 2005 by scripting out the logins on the 2000 server and recreating them on the 2005 server and then doing a backup and restore (2000 to 2005)

    So far this has worked great.

    is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005? I thought that a migration of sorts took place when you did the restore? can anyone explain?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Wait until you try that with a 500 GB database.

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    Hopefully I won't have to .. all of our big databases are on DB2 : )

  4. #4
    Join Date
    Sep 2009
    Location
    Dallas, TX
    Posts
    6
    I assume you are using sp_help_revlogins to do the scripting for you?

    "is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005?" - well, kinda. The problem with doing it this way is that, 999 times out of 1000, you are moving to a new machine (bigger, better hardware) so it's a migration instead of an upgrade. So is it likely that people do upgrades? Sure - happens all the time when Big Software Vendor tells Little Client that they must use SQL 2005 yet Little Client doesn't want to buy new hardware.

    But that's not likely happening in a 500GB database situation!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •