If the answer is helpful, please click " Accept Answer" and upvote it. A Subscriber to a merge publication can be all versions equal to or lower than the Publisher version which are supported as per the versions life cycle support cycle.ĭetails you may check: Upgrade or patch replicated databases.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. A Subscriber to a transactional publication can be any version within two versions of the Publisher version.Subscriber version depends on the type of publication:.A Publisher can be any version as long as it less than or equal to the Distributor version.A Distributor can be any version as long as it is greater than or equal to the Publisher version (in many cases the Distributor is the same instance as the Publisher).Ensure that you adhere to the rules regarding which versions are supported in a topology: Publisher is a desktop publishing software with features for page layout and design. It bears a resemblance to Microsoft Word but is more related to the commercial Adobe InDesign (part of Adobe’s expensive Creative Cloud) and free Scribus software. SQL Server supports upgrading replicated databases from previous versions of SQL Server it is not required to stop activity at other nodes while a node is being upgraded. Microsoft Publisher might be the program that’s best suited for this if you are on Microsoft 365.
0 kommentar(er)
