Post reply

Reporting Services Database : Change Compatibility Level

  • November 28, 2017 at 6:00 am

    #341036

    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

  • November 28, 2017 at 6:56 am

    #1969681

    river1 - Tuesday, November 28, 2017 6:00 AM

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply