[DONE] Database Compare

Feature requests and their debate

[DONE] Database Compare

Postby Wichart009 » Fri Oct 05, 2012 4:30 pm

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.
Wichart009
 
Posts: 7
Joined: Mon Aug 13, 2012 4:42 pm

Re: Database Compare

Postby Serge » Mon Oct 08, 2012 8:32 am

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!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Database Compare

Postby joselitux » Thu Oct 25, 2012 12:13 pm

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

Re: Database Compare

Postby Serge » Fri Oct 26, 2012 4:03 pm

Ok.
There is a huge chance that compare function will be included in the next version)
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Database Compare

Postby joselitux » Thu Nov 08, 2012 9:15 am

and an ALTER Script as a result of comparison? that would be light years far from any other database software.
joselitux
 
Posts: 43
Joined: Thu Oct 25, 2012 12:11 pm

Re: Database Compare

Postby Serge » Fri Nov 09, 2012 9:17 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: [DONE] Database Compare

Postby joselitux » Sat Dec 29, 2012 11:02 pm

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

http://schemasync.org
joselitux
 
Posts: 43
Joined: Thu Oct 25, 2012 12:11 pm

Re: [DONE] Database Compare

Postby Serge » Thu Jan 24, 2013 8:15 pm

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: [DONE] Database Compare

Postby joselitux » Fri Jan 25, 2013 6:32 pm

thanks a lot for your efforts
joselitux
 
Posts: 43
Joined: Thu Oct 25, 2012 12:11 pm


Return to Feature Requests



Who is online

Users browsing this forum: Google [Bot] and 6 guests