We recently migrated our Lansweeper database from SQL Server 2012 to a new server with SQL Server 2017. The database was first created on the SQL 2012 server and therefore was automatically assigned a database compatibility mode setting of 110 (the value for SQL 2012). Now that the database has been migrated to SQL Server 2017, should the compatibility mode setting be updated to 140 (the value for SQL 2017)? Or should it stay where it is?
We are running Lansweeper 7.2.105.2 and have not had any issues. The closest question to this one I could find was the one linked below. The poster basically had the same question and there were some responses but no one actually answered the question.
https://www.lansweeper.com/forum/yaf_postst15270_SQL-Server-2016-Compatibility-for-Lansweeper-DB.aspx#post51583
Thank you in advance ...
Kerry
