May 17, 2015 at 10:00 pm
Hi,
We have installed 2014 sql server. We have currently 2008r2. We have to run the real time report. So we need to set up transactional replication b/n those two servers. We need to use 2008r2 as publisher and 2014 as subscriber.
Is it ok to have subscriber higher version than the publisher? What kind of the issues we might get?
May 18, 2015 at 1:23 am
ramana3327 (5/17/2015)
Hi,We have installed 2014 sql server. We have currently 2008r2. We have to run the real time report. So we need to set up transactional replication b/n those two servers. We need to use 2008r2 as publisher and 2014 as subscriber.
Is it ok to have subscriber higher version than the publisher? What kind of the issues we might get?
From MSDN - "Replication is supported if each SQL Server endpoint is within two major versions of the current version of SQL Server", so 2008R2 and 2014 should fit within those limits.
May 18, 2015 at 1:26 am
Furthermore the distributor has to be the highest version present in the topology, so the distributor will have to be on a SQL 2014 instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 6:33 am
Thank you
August 18, 2015 at 8:44 am
GilaMonster (5/18/2015)
Furthermore the distributor has to be the highest version present in the topology, so the distributor will have to be on a SQL 2014 instance.
The only documentation I have managed to locate on this is https://technet.microsoft.com/en-us/library/ms143241.aspx.
This includes the statement: "For all types of replication, the Distributor version must be no earlier than the Publisher version."
We wish to do the following:
Publisher - 2012
Distributor - 2012
Subscriber - 2014
Based on the Microsoft article this seems to be ok. However, based on your statement there would be a problem with this and we would have to have the Distributor use 2014.
Can you clarify? Do you have a reference as to where I may find these rules.
August 18, 2015 at 8:57 am
Test it out first and see. I can't rmember where, or if maybe I'm misremembering the requirements and I'm not going searching.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2015 at 9:39 am
Thanks
October 9, 2023 at 11:11 am
This post is old, but I think it is interesting to add a note.
I was trying to add a 2019 subscriber to a 2016 publisher with a 2016 distributor with the ms wizard and was receiving the compatibility problem message.
However, we currently have a topology where the publisher and distributor are 2012 and the subscriber is 2016 and it works correctly.
I have tried adding the 2019 sql subscriber to the 2016 publication via script instead of the wizard and it worked correctly.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply