Real Time synchronization scenario RRS feed

  • Question

  • Hi, I would like to synchronize  2 sql server databases but at real time.

    So, synchronization scenario must  fire every time  one of database is updated.

    But I do not like to execute synchronization scenario  on demand.


    Saturday, July 26, 2014 1:03 PM

All replies

  • Sync Fx has to be explicitly invoked and will not fire automatically. 

    have you looked at transactional replication instead? or distributed transaction?

    Thursday, July 31, 2014 7:57 AM