X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id ABF5CD1C4EC for ; Thu, 7 Aug 2003 20:22:28 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23859-06 for ; Thu, 7 Aug 2003 17:21:04 -0300 (ADT) Received: from trill.maridan.net (unknown [212.122.33.162]) by svr1.postgresql.org (Postfix) with ESMTP id 01B94D1C4EE for ; Thu, 7 Aug 2003 17:22:17 -0300 (ADT) Received: from rafcio.polonium.de (130-149-145-132.dialup.cs.tu-berlin.de [130.149.145.132]) by trill.maridan.net (8.9.3p2/8.9.3) with ESMTP id WAA08505 for ; Thu, 7 Aug 2003 22:22:17 +0200 Message-Id: <5.2.0.9.0.20030807222101.01a4e1b0@mail.polonium.de> X-Sender: rafcio@mail.polonium.de X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Thu, 07 Aug 2003 22:21:28 +0200 To: From: Rafal Kedziorski Subject: RE : Oracle to PostgreSQL In-Reply-To: References: <002201c35c10$a12cdd50$0301a8c0@amdosoft.local> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/107 X-Sequence-Number: 9830 hi, At 10:25 07.08.2003 +0200, Bruno BAGUETTE wrote: >"Marco Roda" wrote .. > > Hi, > > > > I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have > > scripts to create the base on Oracle and PostgreSQL (it is about 40 > > tables), but I need to port a great amount of data to PostgreSQL. > > Can anybody help me? > >I never see any documents about migrating from Oracle8 to PostgreSQL, >but I've already done this kind of migration, here's my warrior's way : > >- Make a SQL dump of the tables (structure + constraints + sequences + >data), and try to add this dump file into a PostgreSQL database (via >psql). You will probably need to do several search and replaces in the >SQL code in order to get it PostgreSQL compliant. But as PostgreSQL try >to follow the SQL norm, it shouldn't be very difficult. I have good experiences with: http://www.samse.fr/GPL/ora2pg/ora2pg.html Rafal