Use Command Line to generate data scripts

espo4life

I am trying to use the command line version of SQL Data Compare to generate data scripts for tables in a database. I am trying to use the batch below

cd "C:\Program Files (x86)\Red Gate\SQL Data Compare 10"
SQLDataCompare.exe /s1:Server1 /db1:IVS /scr2:C:\SVN\sandbox\DB-IVS\trunk /Synchronize /include:identical
PAUSE

but it doesnt seem to be working. Does anyone have any experience in trying to do this that can possibly point me in the right direction?

Thanks!
Michael

Brian Donahue

Hi Micheal,

My best guess is that SQL Data Compare is not synchronizing anything because the folder is empty (there is no schema defined). You should use SQLCompare.exe to sync to the folder first.