Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id AA3A5133798E for ; Thu, 24 Feb 2011 05:18:41 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 37791-06 for ; Thu, 24 Feb 2011 09:18:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.techbaza.pl (unknown [84.205.162.156]) by mail.postgresql.org (Postfix) with SMTP id 7C2831336971 for ; Thu, 24 Feb 2011 05:18:32 -0400 (AST) Received: from [192.168.1.204] ([192.168.1.204]) by mail.techbaza.pl ; Thu, 24 Feb 2011 10:18:24 +0100 Message-ID: <4D66225E.8030602@techbaza.pl> Date: Thu, 24 Feb 2011 10:18:22 +0100 From: Piotr Czekalski Organization: TECHBAZA.PL User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; pl; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 ThunderBrowse/3.3.2 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Compare two Data bases Structure References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201102/117 X-Sequence-Number: 35193 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 and even generate suitable SQL script on demand, updating older database to look as a new one (or oposite). This tool is also able to compare project vs database or database vs generation script. Supports not only PostgreSQL but many other databases. It is Java based solution. http://www.sqlpower.ca Regards, Piotr P.S. AFAIK release 0.9.15 was free of charge for personal use. -- -------------------------------------------------------------- "TECHBAZA.PL" Sp. z o.o. Technologie WEB, eDB& eCommerce Oddział Gliwice ul. Chorzowska 50 44-100 Gliwice tel. (+4832) 7186081 fax. (+4832) 7003289