Replication between SQL Server versions

  • SQLDCH

    SSChampion

    Points: 11474

    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
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • free_mascot

    One Orange Chip

    Points: 27168

    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."

  • snitnik

    Valued Member

    Points: 54

    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.

  • Hany Helmy

    SSChampion

    Points: 13321

    Another question for debate!

  • This was removed by the editor as SPAM

  • paul.knibbs

    SSCoach

    Points: 15270

    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.

  • Thorpehall

    Mr or Mrs. 500

    Points: 560

    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.

  • ipounder

    SSCommitted

    Points: 1541

    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.

  • batgirl

    SSCarpal Tunnel

    Points: 4979

    Sorry...you are wrong!

  • Richard Warr

    SSCertifiable

    Points: 6955

    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.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Toreador

    SSChampion

    Points: 11227

    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.

  • suneel kamavaram

    SSCommitted

    Points: 1843

    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.

  • RLilj33

    SSCrazy

    Points: 2146

    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

  • ssimmons 2102

    SSCommitted

    Points: 1634

    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

  • jjtetzlo

    SSCrazy

    Points: 2481

    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 27 total)

You must be logged in to reply to this topic. Login to reply