• I hear transactional replication is complicated and difficult to support.

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

    How often do you need to refresh the destination server?