locked
DB Move SQL 2005 to 2008 RRS feed

  • Question

  • Hello,

    whats the best way to migrate all DBs on MS SQL 2005 Server to a seperate MS SQL 2008 Server
    including all of the Logins and users with rights to the DBS. There are any articles out?

    cheers,
    Marco

     

    Monday, December 6, 2010 10:02 PM

Answers

  • If you don't want to do an in-place upgrade you can use either attach/detach or backup/restore to migrate. You will also need to separately transfer and sync. logins, as well as jobs etc.

    To transfer logins have a look at the following...

    http://support.microsoft.com/kb/246133

    To use attach detach have a look at...

    http://support.microsoft.com/kb/224071

    Remember there can be many dependencies you need to setup first (i.e. backup paths, external application changes etc). Make sure you plan it out and include tests to confirm the migration was successful.

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Proposed as answer by Tom Li - MSFT Wednesday, December 8, 2010 10:02 AM
    • Marked as answer by Tom Li - MSFT Thursday, December 16, 2010 10:26 AM
    Monday, December 6, 2010 11:05 PM