I am attempting to keep a reporting database in sync with our production database. There are about 13 tables, most without PK's, and require a custom key, made of several fields, for comparison. To try and simplify this, I have created a project that includes the requirements and works great to sync the tables manually. But, it does not work when running it from the command line. It appears to do the comparison, but it does not run the update. What am I missing?
I'm currently using the the following syntax:
"C:\Program Files (x86)\Red Gate\SQL Data Compare 10\sqldatacompare.exe" /Project:"c:\DTS Executables\RedgateScripts\MyProject.sdc" /include:identical
Thanks in advance.