Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: Database migration

    Hi All,

    Currently we are working under 2005 sql server platform, and now we need to migrate our DB server to sql server 2008 / 2005 due to hardware issues. Hence please advise us to do the same.. kindly let us know, which platform is more simple to migrate and is there any migration tool (built in or third party ) for doing the same / is it possible to migrate all the databases in a couple of steps?

    Your help would be much appreciated!

    Thanks in advance,
    Goicontini

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You can simply back up the databases on the SQL 2005 box, and restore them on the SQL 2008 box. You will need to recreate any login information, and/or SQL Agent jobs, however. As with anything, copious testing should be required.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Review the output from Upgrade Advisor (it is part of SQL2K8 Feature Pack), and then go from there.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Aug 2010
    Posts
    2
    A quick question to MCrowley, is it possible to do all the database backup / restore in a single step? or do I need to backup each database by one by one and restore it on new server by one by one? please advise

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You will need to back up the databases one by one. Some tools allow for backing up an entire server to tape (Legato, Symantec, etc.), but in the background, these things are also doing individual backups.

Tags for this Thread

Posting Permissions

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