ora2pg
ora2pg copied to clipboard
darold
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 generate...
Hello, When migrating oracle data to Postgres I got this error with ora2pg ERROR (log error enabled): ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly....
I generate the script all_export.sh and it doesn't create the foreign keys. all_export.sh creates all ddl: create tables, unique indexes, indexes, and null constraints but not foreign keys. If I...
Hi Darold, I am working on migrating SQL Server scripts to PostgreSQL using windows version of Ora2PG with scripts migration (offline due to restrictions in our company). Here are few...
Hello Darold, We are currently migrating BLOB objects using the lo_import method, which results in the data type being OID. However, I am encountering difficulties in creating a full-text search...
-this is the text from #1826 - Hello, ora2pg generates reports in multiple formats with `-t SHOW_REPORT` . Those formats are mutual exclusives at run time and there's no other...
Hello, ora2pg generates reports in multiple formats with `-t SHOW_REPORT` . Those formats are mutual exclusives at run time and there's no other way to generate multiple formats outputs at...
Hi, When i run the below command, i am unclear on where to look to resolve this. Please advise: `perl -MFile::Spec -e "print $File::Spec::VERSION;" 3.9`0 `C:\ora2pg>ora2pg -t show_report --estimate_cost -c...
Hi, Using ora2pg version 24.3 and i simply exporting some of the partitions in an Oracle table and no matter what i set, it seems to be exporting all partitions...
Sample Oracle query - CURSOR C_FACTURE_NEW IS SELECT * FROM FACTURE WHERE ACTIDGESTION = P_ACTIDGESTION AND FACID IN ( SELECT FACID FROM DOSRUBECHEANCIER WHERE **DOSID IN (**SELECT DOSID FROM DOSSIER...
Team, I'm currently reviewing the documentation to familiarize myself with the tool, and I have a couple of questions regarding its capabilities: 1. Does the tool detect if stored procedures...
