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
1.01k stars 343 forks source link

Update Ora2Pg.pm: pdated dump_as_json #1728

Closed andreas42 closed 8 months ago

andreas42 commented 8 months ago

Added closing curly bracket for object details. Added quotes around value of "human days cost" and "migration level". These changes are required to turn test reports into syntactically correct JSON, e.g. when processing test reports in a Postgres database using the JSON operators. Finally, formatted object type detail output as JSON array.

mgole001 commented 7 months ago

Hi, thanks for the update. If I need to deploy this new code in my environment, how do I do that? Is it included in version 24.1 or I have to wait for next ora2pg release? I already have version 24.1 deployed in my environment.

darold commented 7 months ago

Proceed as follow:

download https://github.com/darold/ora2pg/archive/refs/heads/master.zip then

unzip master.zip
cd ora2pg-master/
perl Makefile.PL
make
sudo make install