Page 1 of 1

Add features like mysql-utilities (diff, data-compare..)

PostPosted: Fri Feb 27, 2015 1:31 pm
by rethus
Would be really great, if you could include some functions which mysql-utilities give: http://dev.mysql.com/doc/mysql-utilitie ... ls-db.html

Really great feature would be the diff of two DB-Structures, or the Data-Compare & Sync of 2 Databases.

http://drcharlesbell.blogspot.de/2012/0 ... -with.html

Re: Add features like mysql-utilities (diff, data-compare..)

PostPosted: Fri Feb 27, 2015 9:49 pm
by Serge
This feature is already there.
Just select two connections, open context menu and click "Compare".

Re: Add features like mysql-utilities (diff, data-compare..)

PostPosted: Thu Mar 26, 2015 2:42 pm
by rethus
Ok, thank you. But seems not to wok fully.

If I choose " show in Browser" I got the message: Objects compare finished, but no Browser is open with the result.
But if I have a look into /tmp, the HTML-File is created and have resulst. So the "browser open" - operation seems not to be fired!


And BTW: I doesn't mean compair structure, but compair values. I can't find thas option in DBeaver. Is it there?

Re: Add features like mysql-utilities (diff, data-compare..)

PostPosted: Tue Jun 09, 2015 12:14 pm
by sava
Show in browser also doesn't work for me, it doesn't open it in browser (although I see the html file generated in /tmp).
That's not a big issue though, I can select export to file and it works fine.

What would be really nice is to be able to create database sync script in terms of alter commands which will bring database structure to the equal state.

Re: Add features like mysql-utilities (diff, data-compare..)

PostPosted: Tue Jun 09, 2015 12:42 pm
by sava
I noticed one bug:

when comparing 2 schemas, it seems that the comparison script used 'cached' table descriptions because it didn't take into acount newly created fields after connection.
I opened the db connection and went to the table columns, and newly added columns appeared after I hit refresh.