Activity overview
Latest activity by mtmazzitello
Thanks for the Reply. I meant to say SQL DATA Compare, not SQL Compare.
My goal is to keep data updated in database B so it matches database A (which will have the identical schema).
I have found examples of using a command line for SQL Data Compare at http://www.red-gate.com/supportcenter/C ... 419869.htm
but this is just comparing one table to another.
I would like to automate an entire database data compare/sync, ideally using a defined .sdc file that has the table & key mappings defined etc. but if I have to hand code each table and its primary key into the script I guess I can do that also. / comments
Thanks for the Reply. I meant to say SQL DATA Compare, not SQL Compare.
My goal is to keep data updated in database B so it matches database A (which will have the identical schema).
I have found ...
command-line to compare and update one database from another
I want to create a command line application that will use SQL Compare to either execute a .sdc file or whatever code is necessary to compare database B with database A and update database B with an...