Use Command Line to generate data scripts

espo4lifeespo4life Posts: 4
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
Sign In or Register to comment.