Page 1 of 1

[DONE] Database Compare

PostPosted: Fri Oct 05, 2012 4:30 pm
by 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.

Re: Database Compare

PostPosted: Mon Oct 08, 2012 8:32 am
by 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!

Re: Database Compare

PostPosted: Thu Oct 25, 2012 12:13 pm
by joselitux
+1000 to that. and if as a result of comparison an ALTER Script is generated, that would be awesome

Re: Database Compare

PostPosted: Fri Oct 26, 2012 4:03 pm
by Serge
Ok.
There is a huge chance that compare function will be included in the next version)

Re: Database Compare

PostPosted: Thu Nov 08, 2012 9:15 am
by joselitux
and an ALTER Script as a result of comparison? that would be light years far from any other database software.

Re: Database Compare

PostPosted: Fri Nov 09, 2012 9:17 am
by 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.

Re: [DONE] Database Compare

PostPosted: Sat Dec 29, 2012 11:02 pm
by joselitux
The alter script is easy to implement using open source tools like schemasync. Take a look:

http://schemasync.org

Re: [DONE] Database Compare

PostPosted: Thu Jan 24, 2013 8:15 pm
by 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

Re: [DONE] Database Compare

PostPosted: Fri Jan 25, 2013 6:32 pm
by joselitux
thanks a lot for your efforts