Red Gate forums :: View topic - Create data difference CSV files from command line
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Create data difference CSV files from command line

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
barryryan



Joined: 16 Sep 2011
Posts: 5

PostPosted: Fri Sep 16, 2011 9:04 am    Post subject: Create data difference CSV files from command line Reply with quote

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?
Back to top
View user's profile Send private message
aolcot



Joined: 28 Jun 2011
Posts: 25

PostPosted: Fri Sep 16, 2011 10:15 am    Post subject: Reply with quote

Hi. I think you can do this by using the /export:<directory> (or /e) command line option.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Fri Sep 16, 2011 10:37 am    Post subject: Reply with quote

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/Content?p=SQL%20Data%20Compare&c=SQL_Data_Compare\help\9.0\SDC_CL_Switches.htm
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
barryryan



Joined: 16 Sep 2011
Posts: 5

PostPosted: Fri Sep 16, 2011 2:43 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Fri Sep 16, 2011 4:12 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group