The JADE 2022 release meets tomorrow’s business demands.
ever come across "MultiSubnetFailover"? SQL server - ODBC - ADO.NET all support it .... Could the Jade presentation client connect in the same way? This would mean you don't need to change DNS in a DR take-over... the client just connect to the next active end point ....
Would also have to take Jade load balancing into account in the design of this.
Reference location - https://www.sqlshack.com/sql-server-always-on-listeners/