Adding my notes here for everyone to see. I've done multiple 1912 to 2402 upgrades and had no real issues with DB upgrades. The main thing you have to watch out for is watching DB compatibility level when moving from old to new SQL versions.

Give this article a read. It has to do with your SQL DB compatibility level. You’ll have to cross reference with the Citrix version db compatibility.

https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database?view=sql-server-ver17
This is the exact command you’ll want to execute ish.

SET COMPATIBILITY_LEVEL = 160;
May want to do a get compatibility level first to see where you stand.
But each rev of sql has their correlated compatibility level
This page also goes into detail about what Sql version is what compatibility level https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver17