Josh Harrison wrote:
My question is abt the data migration. Im not sure how to try this
with an online oracle database. We are required to run both postgres
and oracle database simultaneously for a couple of months (atleast
till we decide whether we are going to shut down oracle for good !!!).
Since the oracle database is a production database, It will have
updates/inserts during this time. How do you manage that?
Thanks
josh
Check out ora2pg. You can use this perl tool for data migration as well.
http://pgfoundry.org/projects/ora2pg/
Also, While you are converting your DDL and other queries, you could run
'explain analyze' on them to see how good they perform and make
appropriate changes for better performance.
Btw, glad to see that you are planning to move to PG. :)
Mayuresh
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
