How can we help you today? How can we help you today?

Use Command Line to generate data scripts

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
espo4life
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.