Post reply

General Question on Migrating SQL 2000/2005 to SQL 2008

  • March 5, 2010 at 12:38 pm

    #230588

    We have 3 (SQL2000) DB's and 6 (SQL2005) DB's that need to be migrated to VM. These will hopefully be all SQL2008, but we are double checking with vendors on that possibility.

    My general question: What is the best practice to migrate the master db to SQL2008 ?

    I'm comfortable restoring the user databases to these new systems but unsure how to restore master 2000 and 2005 DB on 2008. I've poked around MSDN but would appreciate your thoughts.

    Thanks

  • March 5, 2010 at 1:03 pm

    #1129420

    Short answer, you don't..

    Are you using any of the directly supported upgrade methods, such as side-by-side.. A method such as this can move most of what you really want.

    But master contains WAY to much version specific information for an upgrade..

    CEWII

  • March 5, 2010 at 1:04 pm

    #1129421

    So how would userid's get migrated?

  • March 5, 2010 at 1:14 pm

    #1129429

    If that is all you are worried about then you could build a VERY simple SSIS package that uses the Transfer Logins Task to copy the logins. I would probably set the CopySIDs option to TRUE. Other than logins are there any other things you are worried about getting from master?

    CEWII

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

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