We have an SQL Server 2019 server running on Linux Ubuntu, and we want to migrate to Windows for its user-friendliness, software and hardware compatibility, and readily supportiveness.
To do that, we’re going to use a read-scale cross-platform Availability Group to reduce the downtime, being the primary instance the Linux server and the secondary the Windows one. Note this configuration is not for high availability.
Before starting, see this link for additional details and sample configuration.
The primary node is SQL Server 2019 on Linux with the availability group feature enabled:
The secondary node is SQL Server 2019 on