On Tue, May 9, 2017 at 1:13 AM, PAWAN SHARMA <er.pawanshr0...@gmail.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