Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UXuCn-0005rb-GL
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2013 14:09:53 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UXuCn-000618-03
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2013 14:09:53 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vibhor.aim@gmail.com>) id 1UXuCl-0005zr-5R
	for pgsql-admin@postgresql.org; Thu, 02 May 2013 14:09:51 +0000
Received: from mail-qc0-x22c.google.com ([2607:f8b0:400d:c01::22c])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vibhor.aim@gmail.com>) id 1UXuCi-0006Cz-HA
	for pgsql-admin@postgresql.org; Thu, 02 May 2013 14:09:50 +0000
Received: by mail-qc0-f172.google.com with SMTP id k19so280056qcs.3
	for <pgsql-admin@postgresql.org>; Thu, 02 May 2013 07:09:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:content-type:mime-version:subject:from:in-reply-to:date
	:cc:content-transfer-encoding:message-id:references:to:x-mailer;
	bh=mn9ZtKRUYConIiiGXmc31ss1aIig2nE3Vzr5gkto/CA=;
	b=r6tAdAVX9+9gAigL7b/dGhdPwxXJkqLi5Ru+wRRQ9o1c8ZzTaMGTN65jLqGYJEj+BJ
	FmACwJCsVACRC2tFTkWgDKL9Zm0JXGxavYCtrrNa3Wdlk6gj+ZkbsjL0VJ06VG283kBZ
	PSUA9hjwJdAoluBxDfOIYi65kkteAgYUfbApTKp55IZyq6Qof3UWWHDqb1fd/HJUDqWu
	hifUKxeFxDWk+i4lZS/kJNdawkMioxgaHumBu3H7Yp+HerO3GTZbmPWXNc0ce/os3baI
	hwGeQXPqqG6OmHxYWLT77myzHMiv6z+hklFBQSRR1p24aIprxQM0yEb9J1Xth9BAVV8W
	W8Hg==
X-Received: by 10.229.78.131 with SMTP id l3mr943015qck.85.1367503787670;
	Thu, 02 May 2013 07:09:47 -0700 (PDT)
Received: from [172.24.38.110]
	(70-91-216-177-BusName-NewEngland.hfc.comcastbusiness.net.
	[70.91.216.177])
	by mx.google.com with ESMTPSA id fq5sm11474885qab.2.2013.05.02.07.09.46
	for <multiple recipients>
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Thu, 02 May 2013 07:09:47 -0700 (PDT)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.3 \(1503\))
Subject: Re: Migration from Oracle 11g to Postgresql
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: 
 <CANwDVowrLpzvgizkz+ene1K21ttX3W_voqTVErt8vyDCnPyU6g@mail.gmail.com>
Date: Thu, 2 May 2013 10:09:48 -0400
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <C202FD88-E84A-4DB6-99CB-60B89A4AE1B5@gmail.com>
References: 
 <CANwDVowrLpzvgizkz+ene1K21ttX3W_voqTVErt8vyDCnPyU6g@mail.gmail.com>
To: Silvana Bravo <bravo.silver@gmail.com>
X-Mailer: Apple Mail (2.1503)
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo.silver@gmail.com> wrote:

> Hello, I'm planning a migration of production DBs from Oracle to
> Postgresql. I would like to receive some suggestions, advising or links to
> related subjects. I decided to rewrite all store procedures, that is not a
> problem.  But regarding the data I was thinking in migrating schema by
> schema. First, create all table structures in postgresql schema. Then,
> generate inserts statements from Oracle schema to extract all data. Addapt
> those inserts to the .sql script/s in postgresql schema.
> I'm currently making a POC of that process since the schemas to migrate a=
re
> not so big. Only a few tables have around 1.000.000 of rows.
> That would be the manual migration. Are there some other ways to make thi=
s?
>=20
> Thanks for the support and I'm glad to start with postgres.


You can use Migration Tool kit or xDB Replication solution from Oracle to P=
ostgreSQL.=20
http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replicat=
ion_Server_Users_Guide-51.htm#P6096_508028

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com



--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin