locked
Migration Method from SQL 2005 to 2012 RRS feed

  • Question

  • Good morning,

    I've had a quick look at the related topics and also through books online, but havent been able to find the answer I'm looking for.

    We have a SQL 2005 SP4 database server and are looking to replace this with a brand new SQL 2012 database server.  I'm trying to find the method of least resistance with regard to migration.

    I've had a little bit of a mess around with trying to restore the master database from a backup, this, of course, didnt work.  I was considering shutting the database down, and swapping the master datafiles around and seeing if that worked, tho i suspect that that will just cause me more difficulties.

    Does anybody know the best way to migrate the databases across, or am I going to be best installing SQL 2005 on the new shiny server, restoring all DB's and then upgrading to SQL 2012 using the upgrade wizard?

    Regards

    Andy

    Thursday, November 15, 2012 10:02 AM

Answers

  • http://social.msdn.microsoft.com/Forums/en-US/sqlservermigration/thread/1f9b80b3-54f0-474b-a351-62a218a38718

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Proposed as answer by Shulei Chen Wednesday, November 21, 2012 8:35 AM
    • Marked as answer by Shulei Chen Friday, November 23, 2012 8:54 AM
    Wednesday, November 21, 2012 2:12 AM

All replies

  • why do you want to restore master database backup from SQL Server 2005 to a SQL Server 2012 ?

    do you need to transfer only databases or do you need to transfer some SQL Agents jobs - besides standard maintenance jobs aka full/diff/log backup etc. - and are you using SQL Authentication or Windows authentication to connect to the SQL Server.

    Are you using other parts of SQL Server 2005 - eg. SSAS, SSIS, SSRS - which need to be migrated ?


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Thursday, November 15, 2012 5:44 PM
  • http://social.msdn.microsoft.com/Forums/en-US/sqlservermigration/thread/1f9b80b3-54f0-474b-a351-62a218a38718

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Proposed as answer by Shulei Chen Wednesday, November 21, 2012 8:35 AM
    • Marked as answer by Shulei Chen Friday, November 23, 2012 8:54 AM
    Wednesday, November 21, 2012 2:12 AM