Dear all,
I have a reporting server that is still in version 2012. It uses two databases : dwhReportServer and dwhReportServerTempDB.
This two databases which are in compatibility level 110 are installed on a SQL Server instance which is running in SQL Server 2016.
Can I change the compatibility level of those DBs from 110 to 130?
Also, if I need to rolback this change, can I do it (set it back to 110)?
thank you
Yes you can change it to 130. And setting it back if needed can be easily done. You just change compatibility levels with:
--set to 2016
ALTER DATABASE YourDatabase SET COMPATIBILITY_LEVEL = 130
--or back
ALTER DATABASE YourDatabase SET COMPATIBILITY_LEVEL = 110
Sue