DB Sync using BATCH file Versus SSIS

DBNewbie_2007

Currently, we are using a lot of "command line" data compares/syncs using ".sdc" files. Needless to say, since these are batch files that run weekly, we have quite a few scheduled processes on our server.

I was thinking that it might be easier (and somewhat more managable for me) if I execute the "command line" process in SSIS, wrapped around an SSIS Execute process task? I can use the result of the SSIS execute process to also send me an email at the end to let me know if the process completed correctly.

Does anyone have experience or has anyone tried this already?

Thanks!

chris.buckingham

Your best approach would be to write a small application using the SQL Data Compare API, which would allow you to run the compare and return various email and status messages to order.

Have a look at the examples in this link:

http://help.red-gate.com/help/SQLCompar ... frame.html