Is it possible to migrate SQL Server 2014 AG (Windows 2012, SQL Server 2014) to SQL Server 2017 AG (Windows 2016, SQL Server 2017) using rolling upgrade method?
What I mean is
- Build 2 SQL Server 2017 instance.
- Add the above nodes to the existing cluster.
- Add the new nodes to the existing AG as an additional replica (Async)
- Failover to 2017 server
- Remove the 2014 nodes from Ag
- Remove the 2014 nodes from the cluster.
Would this work or do we have to build everything from scratch?.