I have a SharePoint 2013 Foundation single server farm. My current SQL version is "SQL Server 2008 R2".
I have another server with SQL Server 2016 version and I want to move all content databases to my SQL Server 2016 (using content database detach and attach method).
- Is it possible to use SQL Server 2016 for SharePoint 2013?
- Can we use SQL Server 2016 by changing the compatibility level of database from database properties?
- Any other way to be able to SQL Server 2016 instance for SharePoint 2013?
or do I need to strictly use one of the supported SQL servers by SharePoint 2013 as per Microsoft documentation (SQL Server 2014/2012/2008 R2)?
Thanks in Advance.