Oracle to PostgreSQL converter implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into PostgreSQL database only those records whose key/index value does not exist in the destination table. Otherwise, the application appends the whole table contents to the corresponding PostgreSQL table. If the structures of source and destination tables are different, the program transforms each record of the source table so that it conforms to the destination table structure.
Have more questions? Contact us