March 18, 2014 at 9:23 pm
Comments posted to this topic are about the item Replication between SQL Server versions
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 18, 2014 at 11:28 pm
If I understand correctly; second answer can be consider correct too.
How second answer is applicable: in this scenario distributor needs to be on highest version of SQL Server that participates in replication i.e. SQL Server 2008R2 in given case.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 19, 2014 at 12:54 am
This question is messed up.
Option one:
The distributor needs to be the same version as the publisher
This statement is clearly wrong, as they don't have to be of the same version. It even quotes in the explanation:
For all types of replication, the Distributor version must be no earlier than the Publisher version.
Option two:
The distributor needs to be on the highest version of SQL Server that participates in replication
This statement could be correct, unless there are other members of the replication procedure that can have a higher version then the distributor. Since none were named in the question, it should be considered correct.
March 19, 2014 at 1:19 am
Another question for debate!
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
March 19, 2014 at 2:51 am
This was removed by the editor as SPAM
March 19, 2014 at 3:42 am
snitnik (3/19/2014)
This question is messed up.Option one:
The distributor needs to be the same version as the publisher
This statement is clearly wrong, as they don't have to be of the same version. It even quotes in the explanation:
For all types of replication, the Distributor version must be no earlier than the Publisher version.
Agreed--seems to me the second answer is the most correct one of the three given.
March 19, 2014 at 4:59 am
The problem with this QotD is that none of the given answers are correct, leading most people to choose an answer that is not correct, but is feasible for this particular case.
March 19, 2014 at 5:13 am
In fact whilst the first answer works, the second answer is more correct since an instance of SQL Server 2012 would also do the job.
March 19, 2014 at 5:43 am
Sorry...you are wrong!
March 19, 2014 at 6:19 am
If you didn't know anything about replication you'd say that the first option was pretty much the same as the last one so you'd select option 2.
If you did know about replication you'd select option 2 as the best fit.
March 19, 2014 at 6:29 am
Richard Warr (3/19/2014)
If you didn't know anything about replication you'd say that the first option was pretty much the same as the last one so you'd select option 2.
That's what I did.
As has been pointed out already, the explanation for answer A contradicts the answer.
March 19, 2014 at 6:31 am
free_mascot (3/18/2014)
If I understand correctly; second answer can be consider correct too.How second answer is applicable: in this scenario distributor needs to be on highest version of SQL Server that participates in replication i.e. SQL Server 2008R2 in given case.
I had similar opinion, See here ( Citation from BOL below)
SQL Server 2008 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. Ensure that you adhere to the rules regarding which versions are supported in a topology:
SQL Server 2000 service pack 3 (SP3) is the minimum version required to participate in a replication topology with SQL Server 2008. There is no minimum version required if you use SQL Server 2005.
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).
A Publisher can be any version as long as it less than or equal to the Distributor version.
March 19, 2014 at 7:16 am
Richard Warr (3/19/2014)
If you didn't know anything about replication you'd say that the first option was pretty much the same as the last one so you'd select option 2.If you did know about replication you'd select option 2 as the best fit.
+1
March 19, 2014 at 7:30 am
hmm - I'm pretty sure you can mix versions all you want. You are limited to the general functionality and replication functionality of the lowest version. so to me the "Best answer" was B
March 19, 2014 at 7:39 am
Stewart "Arturius" Campbell (3/19/2014)
snitnik (3/19/2014)
This question is messed up.Option one:
The distributor needs to be the same version as the publisher
This statement is clearly wrong, as they don't have to be of the same version. It even quotes in the explanation:
For all types of replication, the Distributor version must be no earlier than the Publisher version.
Option two:
The distributor needs to be on the highest version of SQL Server that participates in replication
This statement could be correct, unless there are other members of the replication procedure that can have a higher version then the distributor. Since none were named in the question, it should be considered correct.
Agree with this.
I have several instances where the publishers are SQL2008 and 2008R2, the distributor SQL2012 sp1 and the subscribers SQL2012 sp1.
Same here. Just set up a SQL 2012 SP1 distribution server and all other servers involved are SQL 2008 SP3.
- Jeff
Viewing 15 posts - 1 through 15 (of 26 total)
You must be logged in to reply to this topic. Login to reply