I would like to migrate SQL Server 2014 on Windows to SQL Server 2019 on Linux using while running AG.
Is there an option to Add the SQL Server 2019 to the same AG and once the time comes gracefully fail over to the SQL Server 2019 version?
I currently have 3 nodes on the AG using Asynchronous mode (primary and two standby nodes).
In addition what is the suggested clustering method that I should be using in Linux?
Is there something like WSFC or can I use other Linux clustering method?
And finally I am using EC2 at AWS.