compare data via command line

compare data via command line

Postby gl2103 » Wed 08 Jan 2014 21:28

Hi Experts,
It may be a very naive question but I just started to use Oracle DataCompare.
I wanted to use command line to generate compare script to synchronize data for about 100 tables.
I can do that manually without any problems except checking in 100 tables from ~3000 takes some time;
I was able to save connection arguments to file, but I got confused how I can create a compfile with list of tables to pass as an argument?

I would appreciate any help.
George
gl2103
 
Posts: 1
Joined: Wed 08 Jan 2014 21:13

Re: compare data via command line

Postby alexa » Thu 09 Jan 2014 10:16

In fact, there is even no need to save connection arguments to a file.

You can just select the tables that you will need to synchronize on the 'Mapping' page of the New Data Comparison wizard and generate a *.dcomp data comparison document that you can then use in the command line, for example:

Code: Select all
C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle /datacompare /compfile:"D:\mycompdoc.dcomp" /sync:"D:\mysync.sql" /log:"D:\mylog.log" /report:"D:\myreport.html" /reportformat:HTML

Please refer to the 'How To: Compare and Synchronize Data through the Command Line' topic in the product's Help documentation for details. The following articles for another our product may be also helpful:
http://blogs.devart.com/dbforge/how-to-setup-daily-mysql-backup-on-windows.html
http://www.devart.com/dbforge/mysql/studio/mysql-backup.html
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle