I saw a proof a concept where change data capture was turned on in the replicated database and then SSIS could use the change data functions to find...
The copies of the main databases are for reporting purposes. The main dbs are under quite a bit of realtime load so the vendor recommends offloading the data to the...