What Versions can I have for setting up replication ?

  • Hi Team,

    Can anybody help me knowing what versions can I have replication for Publisher , Subscriber and Distributor.

    Do I need to have all 3 servers as same sql server version or can I mix the versions ? what are Limitiations if I have lower and higher versions and what are the recommendations?

    Question 1 :

    What possible SQL Versions can I have for Publisher ?

    What possible SQL Versions can I have for Subscriber ?

    What possible SQL Versions can I have for Distributor ?

    Question 2:

    Also, is there can I have mix of Enterprise and Standard and Express Editions for Publisher, Subscriber and Distributor?

    Thanks in advance.

  • Oracle_91 (2/26/2014)


    Hi Team,

    Can anybody help me knowing what versions can I have replication for Publisher , Subscriber and Distributor.

    Do I need to have all 3 servers as same sql server version or can I mix the versions ? what are Limitiations if I have lower and higher versions and what are the recommendations?

    Question 1 :

    What possible SQL Versions can I have for Publisher ?

    What possible SQL Versions can I have for Subscriber ?

    What possible SQL Versions can I have for Distributor ?

    Question 2:

    Also, is there can I have mix of Enterprise and Standard and Express Editions for Publisher, Subscriber and Distributor?

    Thanks in advance.

    QN1 : Check this http://msdn.microsoft.com/en-us/library/ms143241(v=sql.105).aspx

    QN 2: Check this http://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

    Express has some limitations though ..

    --

    SQLBuddy

  • Hi SQLBuddy,

    Thanks so much.

  • You are welcome, Oracle_91 🙂

    --

    SQLBuddy

Viewing 4 posts - 1 through 3 (of 3 total)

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