none
Transnational replication vs transnational updatable replication

    Frage

  • Hi,

    Can we add objects to subscriber in Transnational replication.

    Can we update tables in subscriber in Transnational updatable replication.
    Dienstag, 16. Juli 2013 11:54

Antworten

  • Yes, objects such as triggers, constraints, and indexes can be added to subscribers in Transactional Replication.  Keep in mind that on reinitialization these objects will likely be dropped and need to be re-added.  A pre or post snapshot script works good for this.

    Yes, tables can be updated at the subscribers with Updatable Subscriptions for Transactional Replication.  Keep in mind that Updatable Subscriptions for Transactional Replication has been deprecated and the recommended alternative is Peer-to-Peer Replication.


    Brandon Williams (blog | linkedin)

    • Als Antwort markiert mito access Mittwoch, 17. Juli 2013 05:51
    Dienstag, 16. Juli 2013 15:22

Alle Antworten

  • Updateable Transactional Replication will allow data modifications in subscriber level only

    You can use below link for the consideration for Updateable Transactional Replication

    http://msdn.microsoft.com/en-us/library/ms151718.aspx


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Als Antwort markiert mito access Mittwoch, 17. Juli 2013 05:51
    • Tag als Antwort aufgehoben mito access Mittwoch, 17. Juli 2013 05:51
    Dienstag, 16. Juli 2013 14:02
  • Yes, objects such as triggers, constraints, and indexes can be added to subscribers in Transactional Replication.  Keep in mind that on reinitialization these objects will likely be dropped and need to be re-added.  A pre or post snapshot script works good for this.

    Yes, tables can be updated at the subscribers with Updatable Subscriptions for Transactional Replication.  Keep in mind that Updatable Subscriptions for Transactional Replication has been deprecated and the recommended alternative is Peer-to-Peer Replication.


    Brandon Williams (blog | linkedin)

    • Als Antwort markiert mito access Mittwoch, 17. Juli 2013 05:51
    Dienstag, 16. Juli 2013 15:22
  • Hi

    Thank you for great explanation.

    Mittwoch, 17. Juli 2013 05:50