pgloader loads data from various sources into PostgreSQL. It can transform the data it reads on the fly and submit raw SQLbeforeandafter the loading. It uses the COPY PostgreSQL protocol to stream the data into the server, and manages errors by filling a pair of reject.dat and reject.log files.
地址
1
https://github.com/dimitri/pgloader
OraDump-to-PostgreSQL
1
OraDump-to-PostgreSQL is a program to export data from Oracle dump files into PostgreSQL database. The program does direct reading from the dump, so Oracle installation isnot required. Command line support allows to script, automate and schedule the conversion process.
地址
1
https://www.convert-in.com/ord2pgs.htm
ora2pg
1 2 3
Ora2Pg is a free tool used to migrate an Oracle or MySQL databaseto 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 loadinto your PostgreSQL database.
Ora2Pg can be used fromreverse engineering Oracle databaseto huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database. It is really easy to used and doesn't need any Oracle database knowledge than providing the parameters needed to connect to the Oracle database.
