SQL server compatibility with SAP commerce 2205

[former_member1235703]

I am upgrading SAP commerce 2011 to 2205

Our current SAP commerce is running on MSSQL 2016

in the Third-Party Compatibility for 2205 , For Microsoft SQL server , the support version is 2017 only .

https://help.sap.com/docs/SAP_COMMERCE/a74589c3a81a4a95bf51d87258c0ab15/8c71300f866910149b40c88dfc0d...

Question , can i

- Remain on MSSQL 2016

- Or upgrade to higher version than 2017 (eg. 2019)

[mansurarisoy]

My recommendation would be to update SQL Server to 2017.

For lower versions (e.g. 2014 or 2016) there might be some functions used within SAP Commerce which are available in 2017 but not in the earlier versions. I know one problem when using not-supported (old) SQL server version which is related DATEDIFF_BIG usage within AuxiliaryTablesBasedTaskProvider and related classes. As a workaround it's possible to use the default tasks provider with following property

task.polling.provider=defaultTasksProvider

I didn't encounter another issue with the older SQL Server version usage.For later versions (e.g. 2019) the same issue is possible, there might be some functions used in 2017 but removed from 2019. I am not aware of such function, but it is possible.For most of the usages within SAP Commerce, you will be safe since the function usage within FlexibleQueries are discouraged except some basic and common functions. Of course, there are some exceptional usages (like Auxiliary Task Provider), so it's best to go with the safe way, use the suggested SQL server version 🙂