locked
Migrating 2005 SQL Server to 2012 SQL Server with Database Compatibility as 2008R2 RRS feed

  • Question

  • I need to verify my reasoning.  I want to make sure my logic is correct.

    I am migrating two 2005 SQL Server databases.  However, the application requires that the upgrade be to SQL Server 2008 R2 and not to SQL Server 2012.  My instance is 2012.  If I do a restore and set the compatiblity to 2008R2, will the database operate as a 2008R2 database even though the server is 2012?  I shouldn't then have an issue with the application, correct?


    lcerni

    Thursday, August 1, 2013 5:56 PM

Answers

  • You have obviously not read the documentation regarding compatibility mode.  There is no guarantee, you will need to try it, test it, and verify that it works correctly. To quote from BOL:

    Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.

    • Proposed as answer by Sofiya Li Monday, August 5, 2013 12:31 PM
    • Marked as answer by lcerni Tuesday, August 6, 2013 12:24 PM
    Thursday, August 1, 2013 7:03 PM

All replies

  • You have obviously not read the documentation regarding compatibility mode.  There is no guarantee, you will need to try it, test it, and verify that it works correctly. To quote from BOL:

    Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.

    • Proposed as answer by Sofiya Li Monday, August 5, 2013 12:31 PM
    • Marked as answer by lcerni Tuesday, August 6, 2013 12:24 PM
    Thursday, August 1, 2013 7:03 PM
  • Thank you.  I did not see that in my reading.  Thank you from stopping me from making a terrible mistake.

    lcerni

    Tuesday, August 6, 2013 12:24 PM