compatibility Level

[aachaemenes]

I think we need to have compatibility level check in the main dbadash window or as a report. When we move databases around there are good chances that we miss to match the compatibility level to the new version as this wont happened automatically.

I have missed so many databases and would love to have this if possible.

[DavidWiseman]

On the DB Options tab at root level, you can see a report showing the number of databases with an old compatibility level (Old Compat Level column).

Note: Using an old compatibility level helps maintain the performance characteristics of the previous versions and enables smoother migrations. It's generally better to be on the latest compatibility level, but switching it can cause performance regressions.

I don't think this belongs as part of a daily check on the summary tab, but if you wanted to you could add a custom check for it. A custom report could also be created if you wanted the information in a specific format different from the DB Options tab.