command line sync - any advantage to using source snapshot?

dhtuckerdhtucker Posts: 40 Bronze 2
edited July 21, 2010 1:24PM in SQL Compare Previous Versions
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?
Doug Tucker
Software Engineer / DBA
RenWeb School Management Software

Comments

  • 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.
Sign In or Register to comment.