Page 1 of 1
Command Line Export to Excel Change Records
Posted: Tue 13 Feb 2018 20:07
by ryeuni
Instead of exporting summary, is it possible to export changed records? Just like the GUI.
Re: Command Line Export to Excel Change Records
Posted: Wed 14 Feb 2018 09:17
by AlexandrS
Greetings!
Thank you for contacting Devart support team.
Could you specify what exactly do you mean under "Just like the GUI" please?
Re: Command Line Export to Excel Change Records
Posted: Wed 14 Feb 2018 21:17
by ryeuni
In the GUI, after comparison finished, at the top panel, it shows the summary of
"Source Object", "Only in Source", "Different Records", "Identical Records", "Only in Target", "Target Object", etc..
That's good. And thru command line export to excel, I get those numbers.
In the GUI, after comparison finished, if I click on a number in "Only in Source" or any number cell at the top panel, below it displays exact records that are associated.
And I don't see that level of details in the Excel export.
I want to know exactly which records are "Only in Source", "Different Records" the changes (field and value), and "Only in Target". Just like the GUI displayed.
There must be a way to export it to Excel. What is the Command Line for this detail of export to Excel?
Re: Command Line Export to Excel Change Records
Posted: Fri 16 Feb 2018 12:10
by alexa
You can use the following command line string:
Code: Select all
set p=%ProgramFiles%\Devart\dbForge Studio for Oracle
"%p%\dbforgeoracle.com" /datacompare /compfile:"file_name.dcomp" /report:"report_name.xls" /incdata:yes /reportformat:XLS /sync:"Output.sql"
pause