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
compare data via command line
Re: compare data via command line
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:
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- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html
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
http://blogs.devart.com/dbforge/how-to- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html