Difference in schema

Thread view:

EN - 14 Mar 2007 09:23 GMT

Hello.

I'm looking for software which might give me difference
between schema two databases in Postgresql.
The main purpose is catch difference between production and development db.

Thanks in advance
Regards
EN

Reply to this Message

Ian Wilson - 14 Mar 2007 11:36 GMT

> I'm looking for software which might give me difference
> between schema two databases in Postgresql.
> The main purpose is catch difference between production and development db.

Although I know nothing of Postgresql, I was going to make a sarcastic
response along the lines of

dbschema -d db1 > db1.schema
dbschema -d db2 > db2.schema
diff db1.schema db2.schema

And then I discovered http://www.thescripts.com/forum/thread420807.html

Reply to this Message

David Harper - 14 Mar 2007 21:00 GMT

> I'm looking for software which might give me difference
> between schema two databases in Postgresql.
> The main purpose is catch difference between production and development db.

It should be relatively easy to write a comparison tool yourself, using
the DatabaseMetaData.getTables and DatabaseMetaData.getColumns methods
to obtain detailed information about the structure of each schema.

David Harper
Cambridge, England

Reply to this Message

mhantula@gmail.com - 19 Mar 2007 02:01 GMT

Check out DB Solo (www.dbsolo.com), it does it for several DBMS
products including PostgreSQL.
The upcoming version also generates a schema synchronization script
for you.

MH

> Hello.
>
[quoted text clipped - 5 lines]
> Regards
> EN

Reply to this Message

Difference in schema

Free Magazines