Need to refresh a data wharehouse nightly with several hundred gig (within
hundred or so files) each eve. Currently the SQL side is running a sql select *
from xxxx for all the tables. The hours of process no longer acceptable.
Starting to look at replication software.
No current journalling. Looking for recommendations that have minimal setup