Re: db dump
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Fri, 15 Mar 2013 13:33:23 +0100
Message-ID: <51431513.7050102_at_mgm-tp.com>
Jose Soares, 15.03.2013 11:54:
> I need to dump an oracle database to convert it to postgresql
> which is the easiest way to do that?
Date: Fri, 15 Mar 2013 13:33:23 +0100
Message-ID: <51431513.7050102_at_mgm-tp.com>
Jose Soares, 15.03.2013 11:54:
> I need to dump an oracle database to convert it to postgresql
> which is the easiest way to do that?
Check out Ora2Pg: http://ora2pg.darold.net/
It can migrate the schema definition (create table, create view, ...) and the data.
It won't get everything 100% right, but is a very good starting point.
Dumping the Oracle data to text files and then use COPY in Postgres is the best option to copy the data. Make sure you read the manual regarding what text format COPY expects.
Regards
Thomas
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 13:33:23 CET