Migrating from PostgreSQL to Oracle

Question

Does anyone knows of an automated tool that works for migrating table structure and data?

The tool has to resolve concerns such as transforming PostgreSQL fields on cases where a direct equivalent isn't available. I.e, a field type like boolean being used.

Answer 1

SwisSQL Data Migration Tool 5.0, it provides data migration between PostgreSQL 7.3.x, 7.4.x and 8.x to Oracle 9i and 10g (and more).

Answer 2

Hi,

you can also try SquirrelSQL (www.squirrelsql.org) - it is open source and has a Hibernate based plugin that can migrate data between any two supported databases.

Boris Cinkler

Answer 3

Navicat has just released a new version, Navicat Premium. I think it supports data transfer between mysql, postgresql and oracle. you can check that out. www.navicat.com