• I forgot to mention two other options:

    CDC

    Change Tracking

    Here is a great article describing these options (compared to Transactional Replication):

    http://www.brentozar.com/archive/2013/09/transactional-replication-change-tracking-data-capture/



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]