Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cmGLU-00022A-V8 for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 08:56:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cmGLU-0003YP-8B for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 08:56:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cmGJh-0006te-Iu for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 08:54:29 +0000 Received: from r0.smtpout1.alwaysdata.com ([2001:41d0:8:4734:1:0:10:1]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cmGJf-0000gb-AE for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 08:54:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=alwaysdata.net; s=carxwol; h=In-Reply-To:Content-Transfer-Encoding: Content-Type:MIME-Version:References:Message-ID:Subject:Cc:To:From:Date: Sender:Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=dJJlG84bsPRsHf7lkTgzWGRIFKfPdn0a1LoNsFPSPps=; b=oAxPoEl3lCYLDglJDn4o38pZvQ 10Cw28yPKmd0hJVeRZkiG9lE7/m8SJyhDjR7kRwfZLpemVmgPvl2N5gIukId37tJc60ZrL6BUd+Pk WGSz5x+jDbo3J0lWfuCpavwLJSwKS7kDDqUWCOcEpuljDElWRy9MzpdLdckE36G0/olY=; Received: from [78.193.183.71] (helo=office.hexack.fr) by smtpout1.roubaix1.alwaysdata.com with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.88) (envelope-from ) id 1cmGJc-0006rs-EJ; Fri, 10 Mar 2017 09:54:24 +0100 Date: Fri, 10 Mar 2017 09:54:35 +0100 From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE To: Mark Kirkwood Cc: "pgsql-admin@postgresql.org" Subject: Re: Oracle to Postgres conversion suggestions? Message-ID: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr> References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz> Organization: HexACK User-Agent: NeoMutt/20161126 (1.7.1) X-alwaysdata-ID: 212968599 X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Le ven. 10 mars, vers 21:42, Mark Kirkwood exprimait : > Hi, Hi, > I've been asked to help with one of these. I'm a bit wary, as I'm thinking > this is actually a really high risk endeavor. Any thoughts on toolkits that > might make this easy? Do you look at ora2pg¹ ? It's a good tool, that estimates the migration cost, migrate what it can automatically (schema, constraints, data ) and let you do the hard job : port your stored procedures and your applications if you didn't use a good ORM. ¹ http://ora2pg.darold.net/ Regards -- Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./ @ stephane@hexack.fr  +33 6 64 31 72 52 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin