Migrating from 2008R2 to 2012... any considerations?

  • Hi,

    This week we will start migrating from SQL2008-R2 to SQL2012. Are they are known issues to consider? Or is it just a matter of restoring the databses from a backup and continue?

    Thanks,

  • Make sure to run it through SQL Server 2012 upgrade advisor to make sure there are no hidden surprises. Also you might want to do depreciated feature analysis in SQL Server profiler to make sure functionality has not been discontinued in SQL 2012.

    If you do not have these issues, backup and restore databases.

    Reference:

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

    Cheers!

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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