Create data difference CSV files from command line

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Create data difference CSV files from command line

Postby barryryan » Fri Sep 16, 2011 9:04 am

I am running Data COmpare from the command line and I would like it to create the data difference CSV files that are created in the UI from Tools\\Export Comparison Results

I have checked the online documentation and can see it is possible to write Synch SQL scripts - but can't see an option for the CSV.

As the comparision will take a relatively long time to perform in my "batch" I don't want to have to open the UI and re-run the project to see the actual differences.

Is there a switch to cause the data difference CSVs to be created?
barryryan
 
Posts: 5
Joined: Fri Sep 16, 2011 8:57 am

Postby aolcot » Fri Sep 16, 2011 10:15 am

Hi. I think you can do this by using the /export:<directory> (or /e) command line option.
aolcot
 
Posts: 25
Joined: Tue Jun 28, 2011 3:13 pm

Postby chriskelly » Fri Sep 16, 2011 10:37 am

Aolcot is correct. You can use /Export: or /e: and specify the directory to generate a .csv file.

Some further details can be found here:
http://www.red-gate.com/supportcenter/C ... ta_Compare\\help\\9.0\\SDC_CL_Switches.htm
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby barryryan » Fri Sep 16, 2011 2:43 pm

I use that option ok to get the summary

"Note that the file created is always called Summary.csv"

but what I want is the details DATA files that are saved in the UI through tools \\ export - not the summary.
barryryan
 
Posts: 5
Joined: Fri Sep 16, 2011 8:57 am

Postby chriskelly » Fri Sep 16, 2011 4:12 pm

Unfortunately, that is currently correct. You cannot get the full output from the command line. I have created a new feature request, reference SDC-1271, for our development team to review.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests