Post reply

Move datbase from 2008 to 2012

  • January 18, 2013 at 4:25 am

    #268827

    I want to move a database from 2008 to 2012.

    Do I

    1. Back up 2008 database

    2. Restore on 2012 instance

    Do I need to change the compatability level at some point?

    Many Thanks

    E

  • January 18, 2013 at 5:41 am

    #1578655

    Nope.. SQL2012 have support for older modes.

  • January 18, 2013 at 5:58 am

    #1578660

    Ok. Thinking about it the wording was not good.

    I do not need to change the compatability level. But is it a good idea to change it to 110 once resteored and checked?

    Thanks

    E

  • January 18, 2013 at 6:00 am

    #1578663

    As long as your application do not use any specific SQL 2008 specific queries etc it should be no problem.

  • January 18, 2013 at 7:27 am

    #1578720

    Yes it is a good idea to change the compat level to the current level, after your apps have been tested against it of course to ensure the SQL they are issuing is supported.

    After restoring to SQL 2012 I would also update all statistics, rebuild all indexes, run CHECKDB and then take a full backup.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 18, 2013 at 8:11 am

    #1578744

    Before making the move I would recommend using the update advisor to see how much work or problems that I might have

    http://msdn.microsoft.com/en-us/library/ms144256.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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