Upgrade SQL Server 2012 from 2008 R2

  • I have a new Server with Windows Server 2012 installed.

    I'm going to install SQL Server 2012 Enterprise Edition.

    I have some SQL Server 2008 R2 Databases which I want upgrade to 2012.

    Can I upgrade without installing 2008 R2 on the new Server?

    If I take the backup and perform a restore what else do I need to do to in addition to setting the compatibility mode?

    Any input would be greatly appreciated.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (8/30/2013)


    just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    Thanks.

    That is what I did when I upgraded database to 2005 & 2008.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Perry Whittle (8/30/2013)


    just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    Hi Perry

    a quick doubt

    Can we use Export import tool to do this job

  • You could, but why would you want to? Restoring a backup's going to be faster and less work.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (8/30/2013)


    You could, but why would you want to? Restoring a backup's going to be faster and less work.

    Just want to know....

    thanks

    i am still a Rookie :hehe:

  • Perry Whittle (8/30/2013)


    just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    In case it gets necessary: You can't restore a 2012 database back to 2008 even if you don't change the compatibility level.

  • SQL Surfer '66 (9/2/2013)


    Perry Whittle (8/30/2013)


    just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    In case it gets necessary: You can't restore a 2012 database back to 2008 even if you don't change the compatibility level.

    No!!!

    Really!!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Why the sarcasm? I learned this myself the hard way once. Hopefully others can avoid it.

  • Good to know, because I almost did that. (See, some of us are still noobs making admittedly dumb mistakes...)

Viewing 10 posts - 1 through 9 (of 9 total)

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