I'm working with a client through the process of modernising their old server infrastructure. They have left a McAfee ePO instance for too long without upgrading and we are now dealing with an unsupported upgrade path.
As part of this modernisation the ePO's database will be moved from a local SQL Server 2008 R2 instance to a new SQL Server 2019 cluster. Unfortunately the current ePO version does not support Server 2019 and the target version does not support Server 2008 R2 so we're hitting a potential impasse.
When the database is migrated to the SQL Server 2019 cluster, it will have its compatibility level (automatically) upgraded to 2012, which is supported by both the source and target server versions.
My question is: from the client perspective is an SQL Server 2019 any different from an SQL Server 2012 if both servers are hosting the same database at the same compatibility level?
Will there be potential connector or API/ABI issues?