X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 914403AA023 for ; Mon, 20 Dec 2004 17:22:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01005-08 for ; Mon, 20 Dec 2004 17:22:29 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id EE47D3AA017 for ; Mon, 20 Dec 2004 17:22:28 +0000 (GMT) thread-index: AcTmuIJfq0QP+/8gRvmWiDvkfaD/9g== Received: from webserver ([10.0.0.10]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 20 Dec 2004 12:22:40 -0500 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 From: "Chris Hoover" To: Date: Mon, 20 Dec 2004 17:22:30 (GMT) X-MSMail-Priority: Normal X-Mailer: AspMail 4.0 4.03 (SMT492C4AF) Subject: Any tools to compare db's MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message-ID: X-OriginalArrivalTime: 20 Dec 2004 17:22:40.0671 (UTC) FILETIME=[823E52F0:01C4E6B8] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.235 tagged_above=0 required=5 tests=INVALID_DATE X-Spam-Level: X-Archive-Number: 200412/203 X-Sequence-Number: 15789 Does anyone know of any good tools that will compare 2 db's and generate = a complete listing of any object differences? I need both the tables, = views, functions, etc. as well as the object permissions. I have tried EMS's PostgreSQL DB Compare, but it does not provide the = permission comparison. Looking for any other tools out there. Thanks for any help. Chris