[DONE] Database Compare

[Wichart009]

If possible, dBeaver should have Database Compare between 2 database, and show the difference. And may compare in detail to the object in the database such as Table, View, Store Procedure, Trigger, etc. This feature helpful for DBA to check the difference between 2 database.

[Serge]

Hi!

Yes, it'd be a great feature. And from the first sight it not so complicated, we can just compare all database objects one by one and print all differences in html report.
I think we can add this feature in one of nearest version but not the next one. Now all our efforts are on Juno migration..

Thanks!

[joselitux]

+1000 to that. and if as a result of comparison an ALTER Script is generated, that would be awesome

[Serge]

Ok.
There is a huge chance that compare function will be included in the next version)

[joselitux]

and an ALTER Script as a result of comparison? that would be light years far from any other database software.

[Serge]

Yes, having alter script just out of the box would be great) However it is reealy complex feature.
Currently DBeaver even doesn't support DDL generation for existing metadata objects (MySQL and Oracle extensions simply reads DDL from server).
We need to implement DDL generation first and then I'll think about the possibility of some valuable DDL diff algorythm..

Thanks.

[joselitux]

The alter script is easy to implement using open source tools like schemasync. Take a look:

http://schemasync.org

[Serge]

Schemasync runs only on linux and only for MySQL while we need multiplatform and multidabase solution.
As far as I know there is no such tool (at least open source).

Anyway, DBeaver API allows generation of basic alter script which will create missing objects (tables, columns, indexes, etc). Most complicated thing is to make existing objects (e.g. table column) the same, i.e. the same type, the same NOT NULL flag, and all other database specific options. ALTER table/column syntax is very database specific and sometimes it is incredibly complex (e.g. in Oracle). There is no chance for us to add such smart alter script generator in observable future.

But if basic version of alter script will make any sense for people we can add it in one of nearest versions.

Thanks

[joselitux]

thanks a lot for your efforts