command line sync - any advantage to using source snapshot?

dhtucker

I'm generating a script to synchronize all databases on a given server (several hundred) against a single target database (on another server).

Is there any advantage to creating a database snapshot to act as the comparison source? I'm looking to avoid/shorten the source registration step that keeps getting repeated.

In addition, would it be advantageous to create the snapshot on the target server and run sqlcompare there, rather than running the comparisons from my administrative machine?

chriskelly

From your situation I believe that the best option for you would be to create a snapshot of the single database, transfer it to the second server (containing your 'several hundred' databases') and run the comparison there.

This should dramatically reduce the load on your network and should also give a noticable performance gain as a result.