Forum OpenACS Q&A: Re: Oracle to Postgres migration

Collapse
Posted by Rajeev Moudgil on
Hello,

We plan to migrate oracle9i schema to Postgres 8.1. We have downloaded the tool ora2pg including the drivers dbi, dbd::pg, dbd::Oracle.

Is there any user manual or a short document on how to use the tool? Has anyone used this tool to convert the oracle schema?

At this stage we are looking for converting only the database objects excluding the stores procedures/triggers etc.

ANy hints / pointers would be greatly appreciated.

Thanks
Rajeev