Bottlenecks / Optimization?
SQL Data Compare can be very slow on large databases, sometimes taking hours to determine the differences (over a VPN connection). What are the common speed bottlenecks? My guess is that the network speed is the main one, but I'm looking to confirm that assumption. Other than removing the very large tables from the comparison, are there any good optimization techniques?
0 · Share on Twitter