Use Command Line to generate data scripts

Compares and synchronizes SQL database content.

Use Command Line to generate data scripts

Postby espo4life » Tue Dec 11, 2012 4: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

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?

Posts: 2
Joined: Wed Oct 31, 2012 5:46 pm

Postby Brian Donahue » Tue Jan 15, 2013 11:23 am

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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests