principlesqlMinor
Which tool to compare an Oracle database with a Postgresql database?
Viewed 0 times
postgresqlwithdatabasecomparewhichoracletool
Problem
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) ?
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) ?
Solution
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.
You have to keep in mind that Oracle and PostgreSQL have quite different table definition clauses which make it difficult to compare them accurately.
Context
StackExchange Database Administrators Q#86786, answer score: 6
Revisions (0)
No revisions yet.