DB Sync using BATCH file Versus SSIS

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!

DBNewbie_2007 December 28, 2007 14:56

Comments

1 comment

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

chris.buckingham December 31, 2007 07:49

0

Add comment

Please sign in to leave a comment.

How can we help you today?

DB Sync using BATCH file Versus SSIS

Comments

Add comment