Command Line Export to Excel Change Records

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
ryeuni
Posts: 2
Joined: Tue 13 Feb 2018 20:04

Command Line Export to Excel Change Records

Post by ryeuni » Tue 13 Feb 2018 20:07

Instead of exporting summary, is it possible to export changed records? Just like the GUI.

AlexandrS
Devart Team
Posts: 20
Joined: Mon 22 Jan 2018 11:27

Re: Command Line Export to Excel Change Records

Post by AlexandrS » Wed 14 Feb 2018 09:17

Greetings!

Thank you for contacting Devart support team.

Could you specify what exactly do you mean under "Just like the GUI" please?

ryeuni
Posts: 2
Joined: Tue 13 Feb 2018 20:04

Re: Command Line Export to Excel Change Records

Post by ryeuni » Wed 14 Feb 2018 21:17

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?

alexa

Re: Command Line Export to Excel Change Records

Post by alexa » Fri 16 Feb 2018 12:10

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

Post Reply