Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cmJrw-00051h-4k for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 12:42:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cmJrv-0007JF-EB for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 12:42:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cmJru-0007J5-Un for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 12:42:03 +0000 Received: from mout.perfora.net ([74.208.4.194]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cmJrn-0003ux-Oh for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 12:42:01 +0000 Received: from [192.168.1.50] ([68.98.131.4]) by mrelay.perfora.net (mreueus001 [74.208.5.2]) with ESMTPSA (Nemesis) id 0Lw0OR-1cCESN0PZV-017oC2; Fri, 10 Mar 2017 13:41:46 +0100 Message-ID: <58C29F11.10707@sqlexec.com> Date: Fri, 10 Mar 2017 07:41:53 -0500 From: "michael@sqlexec.com" User-Agent: Postbox 5.0.11 (Windows/20170302) MIME-Version: 1.0 To: =?UTF-8?B?U3TDqXBoYW5lIEtBTlNDSElORQ==?= CC: Mark Kirkwood , "pgsql-admin@postgresql.org" Subject: Re: Oracle to Postgres conversion suggestions? References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz> <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr> In-Reply-To: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr> Content-Type: multipart/alternative; boundary="------------030600060800050008020402" X-Provags-ID: V03:K0:w1Ne4YZ6unOFD9i6G3CdKpOuC3o4zEPk+oAkXkvXqoBgYemfyC/ rcM7+DxBtEw1Mr/uhbWZChwpERkwVcFOVt1+sxC5FBmsVIUN/KO0TntPJXEGnPB4p0Wsm0v AMQ9jJqAOIb280LbG9K87NlY4oWUAffdCPJ2ruDcfjizMtKq2khYJlJ7W3/yekzHcrPnE0r a3DGSFAPVxLUhbDmdUyog== X-UI-Out-Filterresults: notjunk:1;V01:K0:dQxdmiiS1/g=:ycrltHlYNWxwLdl1y5xn64 qZXJO8qGX8kE4qmWqm4XhEEFRvEvtfArJKs0Xm6+EOkfmtQNZGhLexguj7yR3A/g1uvSgDzB8 If0IKNsJ+YSPeC+QQS+Rq6b6R1nsO9gjC+RJJnPBusTEfq4MmNriAIMamcNec9Z6EWQDB0/rF HYpYJJdk20uNteMvQcK1Cljm1JrRQX9GLt6TQ7jqXSHHxq9ppmP5fKdyEPfW2Ar58EEgBWaYN P134wqJ0vRUdqddrdOe3j/E2pB7EIAFdQlXWZiQYtK5qY05t9b1OTwMa5sT1x4vsgS+xPL/7J +yMTy6NzwHTP2PNvHrxuciqRC89vtsj5YfG9d/qfTWvooPQTbGupSL26Vhn6P0EgkoFo+Hiqq o5kZYOcnXgPlg18Mmsf+BRV4B7KfspiBuqwQzau8aIPUP+2BRxihADmJiUJm0CM0ufxlhOi9t v8/p5VuuJwz0OsNX/1fr+S3Y7MexfReXELn/b9s5c5DdOJtS/1mHqSBR0vIRx13F5n/RidkUv JTVKhlEcR03sxmmnq4bKxYcbHM1jVeaOXixm+vExe0bQIu+qBtjB/MmtxGIJU2lXTkqAdENRQ 0wUMtpJ2Ek0dTzjPxwybL/F3fh4xxqevkwEghlwDWXsXoHs8/fgfZZtI0lgNGWtZ9iG/SS8Nn gjGER3AsR9Nwcrg7jGOZnzwdP1/V/6O19P/Z1pmKeD/98ddhu3vcNToJN+Vcsl3EJ4pBFeQIW Gs2EPlJUboNExXrg X-Pg-Spam-Score: -1.9 (-) 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 This is a multi-part message in MIME format. --------------030600060800050008020402 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit You might want to consider using oracle_fdw (thinking rolling migration) in conjunction with Ora2pg (foreign keys, etc). Also, there are good commercial tools out there like FullConvert. Regards, Michael Vitale > Stéphane KANSCHINE > Friday, March 10, 2017 3:54 AM > 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 > Mark Kirkwood > Friday, March 10, 2017 3:42 AM > 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? > > > details: > > - db size approx 5TB > > - blob and (Oracle) spatial datatypes involved > > - conversion and heterogeneous replication solutions needed > > > Currently looking at Amazon schema conversion/data migration services > but wondering if there are known good solutions out there! > > > Cheers > > > Mark > > > --------------030600060800050008020402 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit You might want to consider using oracle_fdw (thinking rolling migration) in conjunction with Ora2pg (foreign keys, etc).  Also, there are good commercial tools out there like FullConvert.

Regards,
Michael Vitale

Friday, March 10, 2017 3:54 AM
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
Friday, March 10, 2017 3:42 AM
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?


details:

- db size approx 5TB

- blob and (Oracle) spatial datatypes involved

- conversion and heterogeneous replication solutions needed


Currently looking at Amazon schema conversion/data migration services but wondering if there are known good solutions out there!


Cheers


Mark




--------------030600060800050008020402--