4

We are currently migrating an Oracle database 10gR2 to a Postgresql database 9.3. Thanks to Hibernate, all tables can be recreated seamlessly.

However, the Oracle database is huge. We are going to write a small tool that will bring the data from one db to the other.

We want to check the quality of the migration with some kind of third-party database comparator.

Do you know a tool that can compare an Oracle database and a Postgresql database (schema + data) ?

6

You could try the Schema Comparison Tool from dbsolo. I don't know if you can compare different databases with one another.

You have to keep in mind that Oracle and PostgreSQL have quite different table definition clauses which make it difficult to compare them accurately.

2

as far as i know there is no such tool around. however, you got a couple of choices: a.) use oracle_fdw and just join the stuff or b.) export data to text files and use a simple UNIX diff. it works like a charm usually.

0

I recently stumble upon another tool capable of this migration: dbMigration .NET.

enter image description here

Here are some databases supported:

  • Oracle
  • Postgresql
  • SQlite
  • SQL Server
  • ... (see complete list on the site)

It can be installed with chocolatey.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.