W dniu 2011-02-24 01:03, manuel antonio ochoa pisze:
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
I'd advise SQL Power Architect - very handy tool with graphical DB
design capability.
Will compare your databases
On Feb 24, 2011, at 5:33 AM, manuel antonio ochoa wrote:
> How Can I do to compare two structures of data bases ?
>
> DBA != DBB I need wich functions and wich tables are not equals
>
> thnks
You can try with apgdiff.
http://apgdiff.startnet.biz/
Thanks & Regards,
Vibhor
--
Sent via pgs
As an alternative to the other tools - I've had luck using a simple query
that uses information schema.
> How Can I do to compare two structures of data bases ?
>
> DBA != DBB I need wich functions and wich tables are not equals
>
> thnks
Select from information_schema.columns and full outer join it again on the
table and column names, then just look for nulls on either side. You'll need
to alias the left and right views differently. I'm assuming that the dbs are
next to each other in the same installation. Once the base query is wo
