Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 021F3632C6C for ; Mon, 2 Feb 2009 07:51:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35875-01-3 for ; Mon, 2 Feb 2009 07:51:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gunduz.org (ns1.gunduz.org [77.79.103.58]) by mail.postgresql.org (Postfix) with ESMTP id E70D7632C74 for ; Mon, 2 Feb 2009 07:50:50 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.gunduz.org (Postfix) with ESMTP id 69D74400042; Mon, 2 Feb 2009 13:51:39 +0200 (EET) X-Virus-Scanned: amavisd-new at mail.gunduz.org Received: from mail.gunduz.org ([127.0.0.1]) by localhost (mail.gunduz.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id X6uxE0QWj1Ns; Mon, 2 Feb 2009 13:51:37 +0200 (EET) Received: from [192.168.1.3] (evim.gunduz.org [78.189.47.167]) by mail.gunduz.org (Postfix) with ESMTPA id D27F9400033; Mon, 2 Feb 2009 13:51:36 +0200 (EET) Subject: Re: How to migrate from oracle to postgres !! From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: s.borse@direction.biz Cc: "pgsql-admin@postgresql.org" In-Reply-To: <1233315299.2247.33.camel@dss-052.dsslp.com> References: <1233315299.2247.33.camel@dss-052.dsslp.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-XtO3WAdZfOPY5yQkaASn" Date: Mon, 02 Feb 2009 13:50:52 +0200 Message-Id: <1233575452.3357.75.camel@laptop.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 (2.22.3.1-1.fc9) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/2 X-Sequence-Number: 31223 --=-XtO3WAdZfOPY5yQkaASn Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On Fri, 2009-01-30 at 17:04 +0530, Suresh Borse wrote: > How to migrate existing database which in Oracle to postgres? Some people use Ora2Pg for taking data snapshot from Oracle to PostgreSQL: http://pgfoundry.org/projects/ora2pg/ Also, there is another project which adds Oracle compat functions to PostgreSQL, which will help you to port your application easier: http://pgfoundry.org/projects/orafce ..and here is the presentation from Peter. Subject: Porting Oracle applications to PostgreSQL: http://www.pgcon.org/2008/schedule/track/Tutorial/62.en.html -HTH. Regards, --=20 Devrim G=C3=9CND=C3=9CZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org --=-XtO3WAdZfOPY5yQkaASn Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkmG3hoACgkQtl86P3SPfQ67rgCeJg1v8ueD9HUdj8UtfGRZLH00 Cx0AoMKmKaUCH4fn/pnHZPlCHa8CRcuo =Erns -----END PGP SIGNATURE----- --=-XtO3WAdZfOPY5yQkaASn--