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.
Note: this means that the lower-case comparison of the PostgreSQL and Oracle object names will not match exactly in line 17021 of subroutine set_pg_relation_name:
$orig = " (origin: $table)" if (lc($cmptb) ne lc($table));
And the resulting output will show something similar to:
Which is probably fine as it shows the object names with quoted accuracy. However, if not desirable, this the comparison of lc($table) in line 17021 could be modified to strip the double quotes.
Fix for issue https://github.com/darold/ora2pg/issues/1612 by making the Oracle schema and table name quoted identifiers in
SELECT COUNT(*) ...
statement.Note: this means that the lower-case comparison of the PostgreSQL and Oracle object names will not match exactly in line 17021 of subroutine set_pg_relation_name:
And the resulting output will show something similar to:
Which is probably fine as it shows the object names with quoted accuracy. However, if not desirable, this the comparison of
lc($table)
in line 17021 could be modified to strip the double quotes.