Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5F4E81337B4A for ; Wed, 23 Feb 2011 20:16:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 03091-08 for ; Thu, 24 Feb 2011 00:15:56 +0000 (UTC) X-Greylist: delayed 00:06:39.155942 by SQLgrey-1.7.6 Received: from mail137.messagelabs.com (mail137.messagelabs.com [216.82.249.19]) by mail.postgresql.org (Postfix) with ESMTP id 3C963133740B for ; Wed, 23 Feb 2011 20:15:54 -0400 (AST) X-VirusChecked: Checked X-Env-Sender: JRPlugge@west.com X-Msg-Ref: server-2.tower-137.messagelabs.com!1298506153!114834678!1 X-StarScan-Version: 6.2.9; banners=-,-,- X-Originating-IP: [216.57.102.212] Received: (qmail 31927 invoked from network); 24 Feb 2011 00:09:14 -0000 Received: from unknown (HELO mlmail1.west.com) (216.57.102.212) by server-2.tower-137.messagelabs.com with AES128-SHA encrypted SMTP; 24 Feb 2011 00:09:14 -0000 Received: from OMA00CHUB04.corp.westworlds.com (10.27.123.46) by mlmail1.west.com (216.57.102.212) with Microsoft SMTP Server (TLS) id 8.3.137.0; Wed, 23 Feb 2011 18:08:40 -0600 Received: from oma00cexmbx03.corp.westworlds.com ([10.27.116.57]) by OMA00CHUB04.corp.westworlds.com ([10.27.116.71]) with mapi; Wed, 23 Feb 2011 18:09:13 -0600 From: "Plugge, Joe R." To: manuel antonio ochoa , "pgsql-sql@postgresql.org" Content-Class: urn:content-classes:message Date: Wed, 23 Feb 2011 18:09:09 -0600 Subject: Re: Compare two Data bases Structure Thread-Topic: [SQL] Compare two Data bases Structure Thread-Index: AcvTtnQk7e/+pq9QT3e88+uZlB0YbwAAHpGdAAAIFYs= Message-ID: <55D282C4-D8E6-4548-9248-EB9F3340B074@mimectl> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US x-mimectl: Produced By Microsoft Exchange V8.3.105.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201102/115 X-Sequence-Number: 35191 Check out DB Solo ... http://www.dbsolo.com/ Does both DDL compare as well as data compare. ________________________________ From: pgsql-sql-owner@postgresql.org [pgsql-sql-owner@postgresql.org] On Be= half Of manuel antonio ochoa [manuel8aalfaro@gmail.com] Sent: Wednesday, February 23, 2011 6:03 PM To: pgsql-sql@postgresql.org Subject: [SQL] Compare two Data bases Structure How Can I do to compare two structures of data bases ? DBA !=3D DBB I need wich functions and wich tables are not equals thnks