Use Command Line to generate data scripts

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Use Command Line to generate data scripts

Postby espo4life » Tue Dec 11, 2012 5:17 pm

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

Code: Select all
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
 
Posts: 2
Joined: Wed Oct 31, 2012 6:46 pm

Postby Brian Donahue » Tue Jan 15, 2013 12:23 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron