ora2pg
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL. (by darold)
OpenLogReplicator
Open Source Oracle database CDC (by bersler)
| ora2pg | OpenLogReplicator | |
|---|---|---|
| 3 | 2 | |
| 960 | 248 | |
| - | - | |
| 9.0 | 8.7 | |
| 24 days ago | 10 days ago | |
| Perl | C++ | |
| GNU General Public License v3.0 only | GNU General Public License v3.0 only |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ora2pg
Posts with mentions or reviews of ora2pg.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-28.
-
Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX
It seems that Oracle customers started using the Auto Index feature. I can see that when they migrate to YugabyteDB. YugabyteDB Voyager is a tool to ease the migration of schema and data. As YugabyteDB is PostgreSQL compatible, ora2pg is used when the source is Oracle. It extracts the schema and data. Some customers moving from Oracle ATP managed service (Autonomous Transaction Processing) reported that a few indexes were not extracted: the ones that have been created automatically by the Automatic Indexing feature of Oracle 19c.
-
Features I'd Like in PostgreSQL
Have you heard of "ora2pg"? It works for both MySQL and Oracle:
https://github.com/darold/ora2pg
https://ora2pg.darold.net/
- Using Ora2Pg to Migrate Data from Oracle to openGauss
OpenLogReplicator
Posts with mentions or reviews of OpenLogReplicator.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-04-22.
- FLaNK AI-April 22, 2024
-
Features I'd Like in PostgreSQL
Good luck with that! Oracle have never made anything that they can't extract money from. In this case look to their attempts to kill logminer (which most CDC systems eg. Debezium use) and force you to pay for Goldengate hub/microservices/cloud.
Not tried it, but https://github.com/bersler/OpenLogReplicator
What are some alternatives?
When comparing ora2pg and OpenLogReplicator you can also consider the following projects:
pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
rum - RUM access method - inverted index with additional information in posting lists
pg_hint_plan - Extension adding support for optimizer hints in PostgreSQL
gql-sql-pgq-pointers
Hashids.java - Hashids algorithm v1.0.0 implementation in Java
ora2pg vs pg_plan_guarantee
OpenLogReplicator vs postgres-operator
ora2pg vs pg_ivm
OpenLogReplicator vs pg_ivm
ora2pg vs rum
OpenLogReplicator vs pg_hint_plan
ora2pg vs gql-sql-pgq-pointers
OpenLogReplicator vs gql-sql-pgq-pointers
ora2pg vs postgres-operator
OpenLogReplicator vs Hashids.java
ora2pg vs pg_hint_plan
OpenLogReplicator vs rum