Share via

Do I change RS dbs' compatibility level after movement to a newest MSSQL?

Miroshnichenko, Valentin 20 Reputation points
2023-10-04T18:19:30.9233333+00:00

I will move Reporting Services' databases from MSSQL 2016 server to a new MSSQL 2019.

Should I manually change dbs' compatibility level to 2019 at some point or it's recommended to leave it in 2016 compatibility level?

Thanks in advance.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,063 questions
SQL Server | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Greg Low 1,980 Reputation points Microsoft Regional Director
    2024-02-29T07:37:37.3933333+00:00

    Based on the details in this article: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-a-report-server-database?view=sql-server-ver16, SSRS now automatically upgrades databases when required. What I would make sure, is that I ran the Report Server Configuration tool, and used it to connect to the report server database. That lets it upgrade it if necessary.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.