Re: [HACKERS] Database schema diff

2015-10-15 Thread Pavel Golub
Hello, Michal. Take a look in MicroOLAP Database Designer for PostgreSQL. You may use it in such way: 1. Reverse Engineering for existent database 2. Apply some changes 3. Modify database - you will get SQL script with all changes http://microolap.com/products/database/postgresql-designer/ You

Re: [HACKERS] Database schema diff

2015-10-14 Thread Michal Novotny
Hi Christopher, thanks a lot for your suggestion however I need to run against dump files so it's useless for me. Thanks anyway, Michal On 10/13/2015 07:23 PM, Christopher Browne wrote: > On 13 October 2015 at 11:48, Michal Novotny > mailto:michal.novo...@trustport.com>> wrote: > > Hi guys

Re: [HACKERS] Database schema diff

2015-10-14 Thread Michal Novotny
I have to admit I was having the same idea few years ago however I never got to implement it, nevertheless I should mount 2 trees for diff comparison, isn't that correct? I mean to mount as /mnt/dumps/old and Few years ago I developed a tool called fsgateway > (https://github.com/mk8/fsgateway)

Re: [HACKERS] Database schema diff

2015-10-14 Thread Michal Novotny
Hi, thanks a lot for your reply, unfortunately it's not working at all, I run it as: # java -jar apgdiff-2.4.jar But it's stuck on the futex wait so unfortunately it didn't work at all. Thanks for the reply anyway, Michal On 10/14/2015 01:53 PM, Иван Фролков wrote: >> I would like to ask yo

[HACKERS] Re: [HACKERS] Database schema diff

2015-10-14 Thread Иван Фролков
> I would like to ask you whether is there any tool to be able to compare > database schemas ideally no matter what the column order is or to dump > database table with ascending order of all database columns. Take a look a tool called apgdiff http://apgdiff.com/ Its development seems suspended, b

Re: [HACKERS] Database schema diff

2015-10-14 Thread Torello Querci
Few years ago I developed a tool called fsgateway ( https://github.com/mk8/fsgateway) that show metadata (table, index, sequences, view) as normal files using fuse. In this way to yout can get differences between running db instance using diff, meld or what do you prefear. Unfortunally at the mome

Re: [HACKERS] Database schema diff

2015-10-14 Thread Shulgin, Oleksandr
On Tue, Oct 13, 2015 at 5:48 PM, Michal Novotny < michal.novo...@trustport.com> wrote: > Hi guys, > > I would like to ask you whether is there any tool to be able to compare > database schemas ideally no matter what the column order is or to dump > database table with ascending order of all databa

Re: [HACKERS] Database schema diff

2015-10-13 Thread Christopher Browne
On 13 October 2015 at 11:48, Michal Novotny wrote: > Hi guys, > > I would like to ask you whether is there any tool to be able to compare > database schemas ideally no matter what the column order is or to dump > database table with ascending order of all database columns. > > For example, if I h

[HACKERS] Database schema diff

2015-10-13 Thread Michal Novotny
Hi guys, I would like to ask you whether is there any tool to be able to compare database schemas ideally no matter what the column order is or to dump database table with ascending order of all database columns. For example, if I have table (called table) in schema A and in schema B (the time di