From: | Silvana Bravo <bravo(dot)silver(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Migration from Oracle 11g to Postgresql |
Date: | 2013-05-02 13:57:52 |
Message-ID: | CANwDVowrLpzvgizkz+ene1K21ttX3W_voqTVErt8vyDCnPyU6g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2013-05-02 14:04:55 | Re: Migration from Oracle 11g to Postgresql |
Previous Message | Jim Mercer | 2013-05-02 12:58:49 | Re: Installing multiple instances of Postgred on one FreeBSD server |