Command Line Export to Excel Change Records
Command Line Export to Excel Change Records
Instead of exporting summary, is it possible to export changed records? Just like the GUI.
Re: Command Line Export to Excel Change Records
Greetings!
Thank you for contacting Devart support team.
Could you specify what exactly do you mean under "Just like the GUI" please?
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
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?
"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
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