Client is requesting the latest MSSQL version, 2022, any known compatibility issues with Ignition? I assume no, but thought it was worth an ask.
If anything you might need a newer JDBC driver, but otherwise I’d expect it to work.
SQL Server 2022 is not yet in the support matrix I always refer people to. It seems it’s not fully released yet, only in Public Preview.
Thanks, I just noticed it isn’t fully released.
@Kevin.Herron it appears it is now in the support matrix, however, it looks like IA doesn't have it listed here, Database Connections - Ignition User Manual 8.1 - Ignition Documentation
Is 2022 fully supported? I'm asking because my answer means a lot less than yours. The client wants that warm fuzzy that only you can provide.
I've pinged the QA team... I'll let you know if there's any warm fuzzies to be had here.
No warm fuzzies
Not to say it doesn't work, just that they're still using 2019 in their test setup right now.
FWIW, I think not everything in the support matrix has necessarily been tested / is tested... some of them maybe just be listing what the JDBC driver claims support for.
@Kevin.Herron We are moving forward to SQL Server 2022 upgrades over the next few months, any updates or issues to note? Thanks!
I wouldn't expect any issues... just make sure your JDBC driver is one listed as supporting 2022 in the compatibility matrix I linked to above.
I just checked "C:\Program Files\Inductive Automation\Ignition\user-lib\jdbc" and I am running "mssql-jdbc-7.2.1.jre11"
The gateway was an early version 7 that has been upgraded over the years and is now 8.1.17. Looks like I need at least 12.2 for compatibility, I'll have to update the jdbc.
FWIW, we're using SQL Server 2022 for a full-blown MES currently and haven't run into issues that have to do with the driver or some unsupported feature. Not that we test everything extensively, we just haven't seen anything in normal to moderately-heavy use.
which jdbc are you using and which version of ignition are you running?
I didn't even really take that into consideration - I either used the jdbc driver that was included with Ignition or the one they link to in their docs. I'm using Ignition version 8.1.38 or so, but we've used it down to 8.1.16 (though it probably works with earlier versions).
This server was version 7.X and upgraded to version 8.1.17 over time. From reading the docs, it doesn't update jdbc's for backwards compatibility, but if I'm updating the database I need to update the jdbc to match.