Using SQL Data Compare version 220.127.116.118 Pro
Command Line job to update a database on server B from the same database on server A. (identical schemas)
PROBLEM - job is taking over 2 hours to complete scheduled job.
Network speed is good.
Not a lot of new data to update each night.
Databases is large however ~ 80GB but only has 6 tables
Why is it taking so long ?
Any help appreciated.