Activity overview
Latest activity by fstanzini
The Data Compare is doing a Database to Database compare. There are 2 scripts. One does a reverse compare and saves the data as a SQL Script. the second does the compare and syncronizes the data.
If I run this via the gui it works fine but from the Command line, the SQL file is not created and we get the error message in the log file.
We migrated these scripts from a Ver 7 redgate install and updated the data to point to the new directories on the new server and changed the version number in the command line to be 9 instead of 7.
Was wondering if there was a command line switch that is either missing or now required in version 9
Thanks / comments
The Data Compare is doing a Database to Database compare. There are 2 scripts. One does a reverse compare and saves the data as a SQL Script. the second does the compare and syncronizes the data.
...
The whole script was not displayed...
"C:\Program Files (x86)\Red Gate\SQL Data Compare 9\sqldatacompare"
/project:"U:\Upload Projects\Uploads\Puritan_WASHECPDB01.sdc"
/scriptfile:"U:\uploads\Puritan_QA_WASHECPDB01.sql"
/synchronize
/verbose
/out:"U:\UploadLog\Puritan_QA_WASHECPDB01.Log"
/FORCE
I added carrage retures so you can see the entire script
Thanks in advance for your help. / comments
The whole script was not displayed...
"C:\Program Files (x86)\Red Gate\SQL Data Compare 9\sqldatacompare"
/project:"U:\Upload Projects\Uploads\Puritan_WASHECPDB01.sdc"
/scriptfile:"U:\uploads\Purit...
Error in the Log file and Sync does not work for some DB Tab
Running the following Command from a batch file:
"C:\Program Files (x86)\Red Gate\SQL Data Compare 9\sqldatacompare" /project:"U:\Upload Projects\Uploads\Puritan_WASHECPDB01.sdc" /scriptfile:"U:\up...