pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration from Oracle 11g to Postgresql
9+ messages / 8 participants
[nested] [flat]
* Migration from Oracle 11g to Postgresql
@ 2013-05-02 13:57 Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:04 ` Re: Migration from Oracle 11g to Postgresql Igor Neyman <ineyman@perceptron.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:34 ` Re: Migration from Oracle 11g to Postgresql Simpson, John (IMS) <SimpsonJ@imsweb.com>
0 siblings, 4 replies; 9+ messages in thread
From: Silvana Bravo @ 2013-05-02 13:57 UTC (permalink / raw)
To: pgsql-admin
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 are
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 this?
Thanks for the support and I'm glad to start with postgres.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
@ 2013-05-02 14:04 ` Igor Neyman <ineyman@perceptron.com>
3 siblings, 0 replies; 9+ messages in thread
From: Igor Neyman @ 2013-05-02 14:04 UTC (permalink / raw)
To: Silvana Bravo <bravo.silver@gmail.com>; pgsql-admin
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Silvana Bravo
Sent: Thursday, May 02, 2013 9:58 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Migration from Oracle 11g to Postgresql
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 are 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 this?
Thanks for the support and I'm glad to start with postgres.
----
Oracle has so called "heterogeneous services" that would allow to connect directly (creating db link) to Postgres ODBC data source, that you could point to your Postgres database.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
@ 2013-05-02 14:09 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
3 siblings, 0 replies; 9+ messages in thread
From: Prashanth Ranjalkar @ 2013-05-02 14:09 UTC (permalink / raw)
To: Silvana Bravo <bravo.silver@gmail.com>; +Cc: pgsql-admin
Yes, You can use the mentioned method by using scripts or also there are
few migration tools available to perform the migration of schema..
**
*Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*Email:prashant.ranjalkar@gmail.com*
*Skype:prashanth.ranjalkar*
*www.postgresdba.net*
On Thu, May 2, 2013 at 7:27 PM, 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
> are 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 this?
>
> Thanks for the support and I'm glad to start with postgres.
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
@ 2013-05-02 14:09 ` Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:18 ` Re: Migration from Oracle 11g to Postgresql Leonardo Carneiro <chesterman86@gmail.com>
3 siblings, 1 reply; 9+ messages in thread
From: Vibhor Kumar @ 2013-05-02 14:09 UTC (permalink / raw)
To: Silvana Bravo <bravo.silver@gmail.com>; +Cc: pgsql-admin
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 are
> 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 this?
>
> 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 PostgreSQL.
http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51...
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
@ 2013-05-02 14:18 ` Leonardo Carneiro <chesterman86@gmail.com>
2013-05-02 14:30 ` Re: Migration from Oracle 11g to Postgresql Paul B. Anderson <paul.a@pnlassociates.com>
0 siblings, 1 reply; 9+ messages in thread
From: Leonardo Carneiro @ 2013-05-02 14:18 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
I used full convert to convert firebird DBs to postgresql. with a few
tweaks, works like a charm. never tried with oracle.
On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar <vibhor.aim@gmail.com> wrote:
>
> 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
> are
> > 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
> this?
> >
> > 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
> PostgreSQL.
>
> http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51...
>
> Thanks & Regards,
> Vibhor Kumar
> Blogs:http://vibhork.blogspot.com
> http://vibhorkumar.wordpress.com
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:18 ` Re: Migration from Oracle 11g to Postgresql Leonardo Carneiro <chesterman86@gmail.com>
@ 2013-05-02 14:30 ` Paul B. Anderson <paul.a@pnlassociates.com>
2013-05-02 14:38 ` Re: Migration from Oracle 11g to Postgresql McKinzie, Alan (Alan) <alanmck@avaya.com>
0 siblings, 1 reply; 9+ messages in thread
From: Paul B. Anderson @ 2013-05-02 14:30 UTC (permalink / raw)
To: pgsql-admin
There is also ora2pg. I have not tried it but it looks easy.
http://ora2pg.darold.net/
On 5/2/13 10:18 AM, Leonardo Carneiro wrote:
> I used full convert to convert firebird DBs to postgresql. with a few
> tweaks, works like a charm. never tried with oracle.
>
>
> On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar <vibhor.aim@gmail.com
> <mailto:vibhor.aim@gmail.com>> wrote:
>
>
> On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo.silver@gmail.com
> <mailto: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 are
> > 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 this?
> >
> > 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 PostgreSQL.
> http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51...
>
> Thanks & Regards,
> Vibhor Kumar
> Blogs:http://vibhork.blogspot.com
> http://vibhorkumar.wordpress.com
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:18 ` Re: Migration from Oracle 11g to Postgresql Leonardo Carneiro <chesterman86@gmail.com>
2013-05-02 14:30 ` Re: Migration from Oracle 11g to Postgresql Paul B. Anderson <paul.a@pnlassociates.com>
@ 2013-05-02 14:38 ` McKinzie, Alan (Alan) <alanmck@avaya.com>
2013-05-02 14:49 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: McKinzie, Alan (Alan) @ 2013-05-02 14:38 UTC (permalink / raw)
To: Paul B. Anderson <paul.a@pnlassociates.com>; pgsql-admin
I used ora2pg a couple years ago. I made a few minor changes to fit our specific requirements, but it worked well for our migration to Postgresql.
Alan
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Paul B. Anderson
Sent: Thursday, May 02, 2013 9:30 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Migration from Oracle 11g to Postgresql
There is also ora2pg. I have not tried it but it looks easy. http://ora2pg.darold.net/
On 5/2/13 10:18 AM, Leonardo Carneiro wrote:
I used full convert to convert firebird DBs to postgresql. with a few tweaks, works like a charm. never tried with oracle.
On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar <vibhor.aim@gmail.com<mailto:vibhor.aim@gmail.com>> wrote:
On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo.silver@gmail.com<mailto: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 are
> 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 this?
>
> 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 PostgreSQL.
http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51...
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:09 ` Re: Migration from Oracle 11g to Postgresql Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:18 ` Re: Migration from Oracle 11g to Postgresql Leonardo Carneiro <chesterman86@gmail.com>
2013-05-02 14:30 ` Re: Migration from Oracle 11g to Postgresql Paul B. Anderson <paul.a@pnlassociates.com>
2013-05-02 14:38 ` Re: Migration from Oracle 11g to Postgresql McKinzie, Alan (Alan) <alanmck@avaya.com>
@ 2013-05-02 14:49 ` Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Vibhor Kumar @ 2013-05-02 14:49 UTC (permalink / raw)
To: McKinzie, Alan (Alan) <alanmck@avaya.com>; +Cc: Paul B. Anderson <paul.a@pnlassociates.com>; pgsql-admin
On May 2, 2013, at 10:38 AM, "McKinzie, Alan (Alan)" <alanmck@avaya.com> wrote:
> I used ora2pg a couple years ago. I made a few minor changes to fit our specific requirements, but it worked well for our migration to Postgresql.
Ora2Pg is a good tool for one time migration.
However, when we come to crucial production databases where we have least downtime window. Then replicating data from Oracle to PostgreSQL and later doing switchover to postgreSQL (new database) in short window, is the efficient way I have found and I have used xDB Replication most of time, since its easy to configure and provides GUI mode to monitor your replication etc. I did many migration from Oracle Production database to PostgreSQL. Getting long downtime window for Production is the main issue I have seen for crucial customer facing applications.
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Migration from Oracle 11g to Postgresql
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
@ 2013-05-02 14:34 ` Simpson, John (IMS) <SimpsonJ@imsweb.com>
3 siblings, 0 replies; 9+ messages in thread
From: Simpson, John (IMS) @ 2013-05-02 14:34 UTC (permalink / raw)
To: Silvana Bravo <bravo.silver@gmail.com>; pgsql-admin
I used Ora2Pg to migrate our production databases from Oracle 10g to Postgres a couple years ago. It was extremely simple.
http://ora2pg.darold.net/
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Silvana Bravo
Sent: Thursday, May 02, 2013 9:58 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Migration from Oracle 11g to Postgresql
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 are 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 this?
Thanks for the support and I'm glad to start with postgres.
________________________________
Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2013-05-02 14:49 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-05-02 13:57 Migration from Oracle 11g to Postgresql Silvana Bravo <bravo.silver@gmail.com>
2013-05-02 14:04 ` Igor Neyman <ineyman@perceptron.com>
2013-05-02 14:09 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
2013-05-02 14:09 ` Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:18 ` Leonardo Carneiro <chesterman86@gmail.com>
2013-05-02 14:30 ` Paul B. Anderson <paul.a@pnlassociates.com>
2013-05-02 14:38 ` McKinzie, Alan (Alan) <alanmck@avaya.com>
2013-05-02 14:49 ` Vibhor Kumar <vibhor.aim@gmail.com>
2013-05-02 14:34 ` Simpson, John (IMS) <SimpsonJ@imsweb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox