Post reply

Database conversion from one server to another in SQL Server 2005

  • December 8, 2010 at 11:46 am

    #228308

    Hi All,

    I'm in the process of converting a database in an existing server to another existing server e.g I'm converting database A in Server A to Server B in SQL SERVER 2005.

    A step by step approach to this will be appreciated and any help at all will be also appreciated.

    Thanks,

    Mo

  • December 8, 2010 at 12:16 pm

    #1260269

    When you say "converting", I'm going to interpret that as "copying"...

    The 2 main options are backup/restore and detach/attach, based on whether the "original" needs to stay online.

    If the original does not need to stay online during the copy, then detach/attach is easiest. Detach the database, copy the files to the new server, attach the database.

    If the original does need to stay online during the copy, then backup the original, copy the backup file to the new server, then restore.

    Note, both scenarios only get you the database, you'll still need to port over your server scoped objects such as logins, jobs, etc.

  • December 8, 2010 at 12:22 pm

    #1260276

    Thank you very much for the info. I really appreciate it!

  • December 8, 2010 at 1:08 pm

    #1260294

    I pretty much agree with Henry_Lee except I prefer the backup and restore method. Mainly because I then have two copies of the data.

    Gethyn Elliswww.gethynellis.com

  • December 8, 2010 at 1:11 pm

    #1260295

    Thanks Gethyn. Your input is also appreciated.

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

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