Re: Migration Query

On Tue, May 9, 2017 at 1:13 AM, PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>
wrote:

> Hi All,
>
> Does one any having list of bottlenecks and workarounds while migrating
> data
> from Oracle to Postgresql. like what are thing which we can migrate from
> Oracle database to Postgresql and what we can't?
>

In general you must be able to migrate pretty much any data type to
PostgreSQL. It would be good to understand the data-types specifically used
in the to-be-migrated Oracle database and how that would effect Application
functionality/performance after migrating to PostgreSQL.

If you can provide details on the specific data-types used by Oracle, then,
the required information can be provided. As per my experience as far as
data types are concerned, issues generally crop-up around when migrating
large object types. Having said that, PostgreSQL is rich in supporting side
range of data-types.

Which is the best tool for migration from Oracle to Postgresql?
>

As already suggested, ora2pg is the best open-source tool.

Regards,

Venkata B N
Database Consultant