X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6AE1BD1D16E for ; Tue, 3 Feb 2004 22:26:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75869-02 for ; Tue, 3 Feb 2004 18:26:47 -0400 (AST) Received: from alexandria15.alexsrv15.com (alexandria15.alexsrv15.com [216.74.85.97]) by svr1.postgresql.org (Postfix) with ESMTP id 98CC1D1C9AB for ; Tue, 3 Feb 2004 18:26:44 -0400 (AST) Received: from [65.218.233.130] (helo=icrossing.com) by alexandria15.alexsrv15.com with asmtp (Exim 4.24) id 1Ao90F-0000jT-KT for pgsql-performance@postgresql.org; Tue, 03 Feb 2004 17:26:43 -0500 Message-ID: <40202034.5060407@icrossing.com> Date: Tue, 03 Feb 2004 15:27:00 -0700 From: Kevin Carpenter User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Database conversion woes... References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - alexandria15.alexsrv15.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - icrossing.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/99 X-Sequence-Number: 5623 First just wanted to say thank you all for the quick and helpful answers. With all the input I know I am on the right track. With that in mind I created a perl script to do my migrations and to do it based on moving from a db name to a schema name. I had done alot of the reading on converting based on the miss match of data types that MySQL likes to use. I must say it is VERY nice having a intelligent system that say won't let a date of '0000-00-00' be entered. Luckily I didn't have to deal with any enumerations. So the conversion goes on. I will definitely be back and forth in here as I get the new queries written and start migrating all I can back into the pg backend using plpgsql or c for the stored procedures where required. The mammoth replicator has been working well. I had tried the pgsql-r and had limited success with it, and dbmirror was just taking to long having to do 4 db transactions just to mirror one command. I have eserv but was never really a java kind of guy. Alright then - back to my code. Again thanks for the help and info. Kevin