July 22, 2015 at 8:49 am
Hi All,
I am little confused with the below statement. Regarding Subscriber version which depends on the type of publication.
As per msdn documentation, i am interested in Transactional replication. So, it says: A Subscriber to a transactional publication can be any version within two versions of the Publisher version. What does it mean?
Reference link: https://msdn.microsoft.com/en-us/library/ms143699%28v=sql.120%29.aspx
To be more specific, consider below cases and expecting answers for below:
case 1: if Publisher is on SQL 2005, what all SQL versions can I have as subscribers?
case 2: if Publisher is on SQL 2008/2008 R2, what all SQL versions can I have as subscribers?
case 3: if Publisher is on SQL 2012, what all SQL versions can I have as subscribers?
case 4: if Publisher is on SQL 2014, what all SQL versions can I have as subscribers?
Thanks in advance.
July 23, 2015 at 2:14 am
It might say that but I have a 2005 publisher with a 2014 subscriber running perfectly OK
July 26, 2015 at 8:47 pm
I have used a 2005 Publisher with a 2012 Subscriber. I think if you want to try a mix of SQL versions you should try it in a test environment if you are concerned about it not working.
The other info from BOL about versions that is related to this is that it indicates the Distributor must be at least as current as the Publisher. So, if you have a 2012 Publisher then the SQL instance hosting the Distributor needs to be at least 2012. I have not tested that info from BOL.
August 5, 2015 at 1:31 pm
What they mean is that the distributor will work with versions of SQL Server 2 up or 2 down from the distributor.
With that said, I have had 2000 publishers going through a 2008 distributor to a 2012 subscriber without issues until it came time to upgrade the publishers. It was easier to remove the subscribers and publications and rebuild after the upgrade.
Also, remember that the distributor will work at the lowest version in the group. In my scenario, I have 2 distributors running 2012. I have publishers at 2005. The distributors work at the lowest level so you might have some issues with some of the newer capabilities.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply