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 EFCBC53405 for ; Tue, 5 Apr 2005 13:44:20 +0100 (BST) 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 24121-05 for ; Tue, 5 Apr 2005 12:44:17 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id A0D9E53411 for ; Tue, 5 Apr 2005 13:44:16 +0100 (BST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id j35CMuoJ030991; Tue, 5 Apr 2005 08:22:56 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id j35CiDM11004; Tue, 5 Apr 2005 08:44:14 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 12GRNQMW; Tue, 5 Apr 2005 08:44:12 -0400 Subject: Re: Advice on mysql to postgres conversion. From: Robert Treat To: Theo Galanakis Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 05 Apr 2005 08:44:12 -0400 Message-Id: <1112705053.26170.275.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.031 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/59 X-Sequence-Number: 17072 On Mon, 2005-04-04 at 00:50, Theo Galanakis wrote: > Hi, > I would be keen to find a tool that is capable of comparing > actual data. I need to confirm if a migration from mysql to postgres is > successful. I have tried dbdiff however it appears very slow, as it uses > odbc and pulls data across to network to the client. I'm after something > I could run on the server(linux based) that can compare data, perhaps > some sort of scripting might be able to achieve the results im after. I > would appreciate any advice. > You might want to check out the dbi-link project on pgfoundry.org which should allow you to connect from your postgresql database to your my$ql database. This should give you the ability to write queries comparing the two systems. HTH. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL