Are there any replication features in SQL Server 2019?
Replication features that have been retained in Microsoft SQL Server 2019 (15.x) for backward compatibility, but, which will be removed in a future version of SQL Server. Replication feature changes that might require changes to applications. Steps and considerations when upgrading SQL Servers participating in a replication topology.
Can you upgrade two different versions of SQL Server?
If we first upgrade the secondary server, we have to figure out how the synchronization between the two servers has to be configured, as for some time they will be running with two different versions of SQL Server. We want to upgrade them to SQL Server 2014.
Can a transactional publication be any version of SQL Server?
A Subscriber to a transactional publication can be any version within two versions of the Publisher version. For example: a SQL Server 2012 (11.x) Publisher can have SQL Server 2014 (12.x) and SQL Server 2016 (13.x) Subscribers; and a SQL Server 2016 (13.x) Publisher can have SQL Server 2014 (12.x) and SQL Server 2012 (11.x) Subscribers.
Is it OK to upgrade multiple versions of MSDN?
This is supported, so long as you stick to certain rules, as described in the MSDN article Upgrade Replicated Databases As long as your Distributor is the same version or greater than your Publisher, and a Subscriber is within two versions of the Publisher, which fits in your case so you’re OK.
How to restore a SQL Server database backup to an older version?
To restore the backup to and older SQL Server version On the target SQL instance, create an empty database to hold the data and objects restored from the backup Start ApexSQL Diff Click the New button in the Project management window: In the Source panel: Select Backup from the Source drop-down list In the Destination panel:
Are there any versions of SQL Server that are still supported?
The SQL Server versions you use remain in support by Microsoft. SQL Server supports replication between the two versions of SQL Server. For more information, see SQL Server replication backward compatibility.