locked
Need some help for choosing a replication type RRS feed

  • Question

  • My target is to create a replication process for the following

    Please suggest which type of replication is suitable for this architecture


     




    • Edited by Siva.ej Friday, September 26, 2014 11:03 AM
    Friday, September 26, 2014 10:57 AM

Answers

  • I think Transactional Replication is a good fit. You need to but take in to consideration of Distributor and where you will keep the distributor.

    You could have a dedicated distributor for the republisher else you can have Pull subscriptions so there is no load on the distrubutor and the subscribers control the distribution agent.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Siva.ej Friday, September 26, 2014 1:52 PM
    Friday, September 26, 2014 12:01 PM

All replies

  • You can use both Transactional and Merge replication. However it would be good if you could give your business requirements as well so that we could give proper solution.

    You havent mentioned whether all these publishers and subscribers are going to be in different servers. How far are these servers going to be? Also what would be the version and edition of sql server instances.

    Also let us know whether you want the subscribers to send the data changes back to the publisher. Only after taking into account all of these we would be able to decide which would be a better fit.

    Please check this link to get a better understanding - http://technet.microsoft.com/en-us/library/ms152553%28v=sql.110%29.aspx


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Friday, September 26, 2014 11:38 AM
  • Thanks for the reply

    Each publisher has one server and subscriber has different servers and I dont want to send the data changes back to publisher.

    Friday, September 26, 2014 11:45 AM
  • I think Transactional Replication is a good fit. You need to but take in to consideration of Distributor and where you will keep the distributor.

    You could have a dedicated distributor for the republisher else you can have Pull subscriptions so there is no load on the distrubutor and the subscribers control the distribution agent.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Siva.ej Friday, September 26, 2014 1:52 PM
    Friday, September 26, 2014 12:01 PM
  • Thanks for the suggestion Ashwin. Is any other suggestion from anybody it will be useful for me

    Friday, September 26, 2014 1:54 PM
  • Can you tell me the estimated disk space used for transactional replication for the above process
    Friday, September 26, 2014 2:34 PM