Devart Forums

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

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.

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

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?

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