From s.borse@direction.biz Fri Jan 30 11:53:12 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D092A632C35 for ; Fri, 30 Jan 2009 07:53:12 -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 04495-04 for ; Fri, 30 Jan 2009 07:53:08 -0400 (AST) X-Greylist: delayed 00:06:45.051887 by SQLgrey-1.7.6 Received: from ns1.aaaonlinux.net (NS1.AAAONLINUX.net [70.84.189.18]) by mail.postgresql.org (Postfix) with ESMTP id 0CD06632C30 for ; Fri, 30 Jan 2009 07:53:08 -0400 (AST) Received: (qmail 21062 invoked by uid 508); 30 Jan 2009 11:53:24 -0000 Received: from unknown (HELO direction.biz) (59.163.21.147) by ns1.aaaonlinux.net with SMTP; 30 Jan 2009 11:53:24 -0000 Received: from [172.16.2.20] ([172.16.2.20]) (authenticated user s.borse@direction.biz) by direction.biz (direction.biz) (MDaemon PRO v9.0.0) with ESMTP id md50000317579.msg for ; Fri, 30 Jan 2009 17:14:07 +0530 Subject: How to migrate from oracle to postgres !! From: Suresh Borse Reply-To: s.borse@direction.biz To: "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary="=-A++gUIuWwHqbm1BTyZeR" Organization: DSS Date: Fri, 30 Jan 2009 17:04:59 +0530 Message-Id: <1233315299.2247.33.camel@dss-052.dsslp.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) X-Authenticated-Sender: s.borse@direction.biz X-Spam-Processed: direction.biz, Fri, 30 Jan 2009 17:14:07 +0530 (not processed: spam filter heuristic analysis disabled) X-MDRemoteIP: 172.16.2.20 X-Return-Path: s.borse@direction.biz X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: direction.biz, Fri, 30 Jan 2009 17:14:09 +0530 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/168 X-Sequence-Number: 31215 --=-A++gUIuWwHqbm1BTyZeR Content-Type: text/plain Content-Transfer-Encoding: 7bit Dear All, How to migrate existing database which in Oracle to postgres? Please provide me the solution/limitation for triggers , procedure , packages & views while migrating. Thanks & Regards, Suresh Borse (DBA) --=-A++gUIuWwHqbm1BTyZeR Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Dear All,

How to migrate existing database which in Oracle  to postgres?

Please provide me the solution/limitation for triggers , procedure , packages & views while migrating.


Thanks & Regards,

Suresh Borse
(DBA)

--=-A++gUIuWwHqbm1BTyZeR-- From jared.lopez@gmail.com Fri Jan 30 13:50:20 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 63922632A16 for ; Fri, 30 Jan 2009 09:50:20 -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 30636-01 for ; Fri, 30 Jan 2009 09:49:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by mail.postgresql.org (Postfix) with ESMTP id E9D856324F5 for ; Fri, 30 Jan 2009 09:49:59 -0400 (AST) Received: by yw-out-2324.google.com with SMTP id 3so142323ywj.73 for ; Fri, 30 Jan 2009 05:49:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=yYyRaqp/Mri1mbD7e6+SDXP4APXUqNC0BKxUCNOnFU4=; b=eO6Pr75b0C5WDstIoUVobmtjt8rew6UHw9kBA21QlFSHRHJn8o+uprPKB9i5fnS8QD fPt3owuTP3GHXckUF7QEmxmmYEPT2NkYYYXICEszTOZ8n+una+VUX/0q8QaiZo8gZrKg a+53ltYC7dt+HrpvK7+Qjb4jlr0qKDQl1RNFU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=rvjvXvYyTFDmas39YegL946KGJqNacbd2VreqPljRVa7F6h2MA4a7+RK/LfyTf6Khq 4LeQEItbZ2sY7whNX/DOm6d0lQKd02s8gqcc+pW6upacm09ow9Rj545cmL+lnKfQuvvM asHq12yJAo0un/mCoM57Tr8NMjFYTCVJcpkuA= MIME-Version: 1.0 Received: by 10.100.5.15 with SMTP id 15mr1003478ane.50.1233323398073; Fri, 30 Jan 2009 05:49:58 -0800 (PST) In-Reply-To: <1233315299.2247.33.camel@dss-052.dsslp.com> References: <1233315299.2247.33.camel@dss-052.dsslp.com> Date: Fri, 30 Jan 2009 09:49:58 -0400 Message-ID: <11fe6a3f0901300549r4b9cf18dhb885ca486d6a1fca@mail.gmail.com> Subject: Re: How to migrate from oracle to postgres !! From: Jared Lopez To: s.borse@direction.biz Cc: "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary=0016e645aacc090e330461b37b85 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/169 X-Sequence-Number: 31216 --0016e645aacc090e330461b37b85 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, you can see this link: http://www.enterprisedb.com/products/postgres_plus_as/compatibility.do Or case studio http://it.toolbox.com/blogs/oracle-guide/sony-replaces-oracle-with-enterpri= sedb-8365 Jared L=F3pez L. DBA PostgreSQL Santa Cruz - Bolivia 2009/1/30 Suresh Borse > Dear All, > > How to migrate existing database which in Oracle to postgres? > > Please provide me the solution/limitation for triggers , procedure , > packages & views while migrating. > > > Thanks & Regards, > > Suresh Borse > (DBA) > > --0016e645aacc090e330461b37b85 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, you can see this link:

http://www.enterprisedb.com/products/postgres_plus_as/compatibility= .do

Or case studio
http://it.toolbox.com/blogs/oracle-guide/sony-replace= s-oracle-with-enterprisedb-8365

Jared L=F3pez L.
DBA PostgreSQL
Santa Cruz - Bolivia

20= 09/1/30 Suresh Borse <s.borse@direction.biz>
=20 =20
Dear All,

How to migrate existing database which in Oracle  to = postgres?

Please provide me the solution/limitation for triggers , p= rocedure , packages & views while migrating.


Thanks &am= p; Regards,

Suresh Borse
(DB= A)


--0016e645aacc090e330461b37b85-- From lst_hoe02@kwsoft.de Fri Jan 30 14:22:45 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BD5556325DB for ; Fri, 30 Jan 2009 10:22:45 -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 65362-04 for ; Fri, 30 Jan 2009 10:22:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by mail.postgresql.org (Postfix) with ESMTP id 8D3E762E7C6 for ; Fri, 30 Jan 2009 10:22:42 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id 89F441A11C for ; Fri, 30 Jan 2009 15:22:39 +0100 (CET) Received: from mailer.kwsoft.de (mailer.kwsoft.de [10.5.0.1]) by webmail.kwsoft.de (Horde Framework) with HTTP; Fri, 30 Jan 2009 15:22:39 +0100 Message-ID: <20090130152239.14884127rk66buio@webmail.kwsoft.de> X-Priority: 3 (Normal) Date: Fri, 30 Jan 2009 15:22:39 +0100 From: lst_hoe02@kwsoft.de To: pgsql-admin@postgresql.org Subject: Re: How to migrate from oracle to postgres !! References: <1233315299.2247.33.camel@dss-052.dsslp.com> In-Reply-To: <1233315299.2247.33.camel@dss-052.dsslp.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.3.2) 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: 200901/170 X-Sequence-Number: 31217 Zitat von Suresh Borse : > Dear All, > > How to migrate existing database which in Oracle to postgres? > > Please provide me the solution/limitation for triggers , procedure , > packages & views while migrating. > > > Thanks & Regards, > > Suresh Borse > (DBA) Not long ago someone posted the following link http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL but i honestly don't know how useful it is. Regards Andreas From devrim@gunduz.org Mon Feb 2 11:51:15 2009 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--