We are migrating from our old SQL Server 2016 to a new SQL Server 2022, with plans to upgrade ArcGIS Enterprise from 10.9.1 to either 11.1 or 11.3.
As part of the migration, we noticed that the database on SQL Server 2022 is currently set to the SQL Server 2016 (130) compatibility level.
I am not very familiar with SQL Server, so I have a few questions:
How does the database compatibility level setting influence how SQL Server operates, particularly in relation to our ArcGIS Enterprise geodatabase?
If we change the database compatibility level to SQL Server 2019, will ArcMap users (who are not ready to switch to ArcGIS Pro yet) still be able to connect to and work with the enterprise geodatabase on SQL Server 2022?
Thanks in advance for any guidance.
