Export comparison results

observ · Post by **observ** » Fri 15 Apr 2011 09:12

Hi ,

I do a comparison between yesterday and today db (each day) to see the differences. While the GUI works fine at doing this it is boring. Can you help me automate exporting all the table diff results at once. I am looking to :
- export in a dynamic location
- export without identical records (only differences)
- export as xls
- set the name of the exported file the same as the table.

Any help is appreciated.
Thanks

Alexz · Post by **Alexz** » Mon 18 Apr 2011 08:46

You can automate exporting comparison results as well as comparison and synchronizing process with help of command line using the '/datacompare' main switch and the '/report' option.
But dbForge Studio for MySQL v4.50 generates a simple report with summary information about comparison.
dbForge Studio for MySQL v5.0 will be able to generate an extended report, but, unfortunately, only in UI (not in command line).
We plan to support generating of extended reports through the command line in one of the next versions of the product.

By the way, dbForge Studio for MySQL v5.0 will be available for download this week.

observ · Post by **observ** » Mon 18 Apr 2011 09:31

I am using Data Comparer 2010 for MySQL .
I am referring to the export feature squared with red in this image:
http://img694.imageshack.us/i/compareg.jpg

Alexz · Post by **Alexz** » Mon 18 Apr 2011 10:48

As I said, dbForge Studio for MySQL has the same functionality.
You can access it using the Comparison main menu (Comparison->Generate Comparison Report).

Did you try it?

Alexz · Post by **Alexz** » Thu 21 Apr 2011 07:29

dbForge Studio for MySQL v5.0 is available for download.