search

darold / 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.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

Enhance DATA_EXPORT_ORDER with custom order of Tables. #1710

Closed dcgadmin closed 4 months ago

dcgadmin commented 7 months ago

First a huge thanks for Awesome tool that is continuously getting enrich with new features.

One kind request to enhance below config DATA_EXPORT_ORDER

Currently it only support based on Size/name, it would great to provide custom order or Source query that provide the order in which we would want to load. It can be useful to accelerate Data load further.

darold commented 4 months ago

Commit fae6268 adds this feature.

Allow DATA_EXPORT_ORDER to take a filename at value to be able to give a custom table order.
The file must contain the ordered list of the tables. One table per line in upper case for Oracle.