I have a requirement to upgrade SQL server from 2008 to SQL 2012 for my SharePoint 2010 Application.

Currently I have SharePoint 2010 SP1 version installed in a server and SQL 2008 R2 enterprise version in another server/Database server I want to know if SharePoint 2010 SP1 is fully compatible with SQL 2012 Standard Version? I need to upgrade SQL server from 2008 R2 to 2012.

Please someone confirm this. It will be a great help.

  • Is there any other things need to confirm ?
    – Jerry
    Jun 17, 2019 at 0:52

2 Answers 2


Yes, SharePoint 2010 SP1 or later version is compatible with SQL 2012, please see the requirement below:

enter image description here


Hardware and software requirements (SharePoint Server 2010)


SharePoint 2010 SP1 does support SQL Server 2012. So an upgrade is basically possible.

You noted that you want to upgrade from SQL Server 2008 (R2) Enterprise Edition to SQL Server 2012 Standard Edition. This will bring you some hassle, because SharePoint Search PropertyStoreDB makes use of the DataCompression feature of SQL Enterprise Edition.

There are two ways to work around this problem:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.