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...
Hi,  [2024-03-11 08:58:07] [========================>] 2756/2756 tables (100.0%) end of scanning. FATAL: ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction. Aborting export...
While performing TEST operation, on Function count we are not filtering migration schema or schema from config PG_SCHEMA in Metadata query. currently it is considering all schema in the database,...
**Schema Used** ``` CREATE TYPE pet_t IS OBJECT ( tag_no INTEGER ,NAME VARCHAR2 (60) ,breed VARCHAR2 (100) ); CREATE TYPE zoo_t IS TABLE OF pet_t; CREATE TABLE wild_side ( ID...
Enhancement request - TEST type for schema validation in Oracle to PostgreSQL with procedural object per packages. Assuming all packages is migrated as schema in PostgreSQL. comparing public procedure\packages in...
ora2pg version: ``` ora2pg --version Ora2Pg v24.1 ``` Commandline: `ora2pg -t INSERT -o data-INSERT.sql -b BSA_Topobase_STROM\data -c BSA_Topobase_STROM\config\ora2pg-TOPOBASE_STROM.conf --debug` Table DDL: ``` CREATE TABLE EW_ABGANG_SCH ( FID NUMBER(10) NOT NULL,...
Ora2Pg v23.2 does not convert Oracle Anydata type to PostgreSQL: --- Oracle CREATE TABLE "CTR"."TQ_ACTIV" ( ... "USER_PROP" "SYS"."ANYDATA" , ... --- PostgreSQL CREATE TABLE tq_activ ( ... user_prop ANYDATA...
Vars of type number_array are not being detected by the scanner or converted. number_array does not exist in PLPGSQL number_array should be converted to an appropriate array type for example...
Hi I made a synthetic example for test purpose TEST option. It is important that the tables differ in name based on the destination and source, but the REPLACE_TABLES instruction...
I was wondering if you could provide or have already provided sha256sums for downloads? Thank you for all the work you and others have done for this project.
I tried using the ora2pg tool to migrate from an on-prem SQL Server database to the GCP Cloud SQL but the migration is very slow running with a single thread....
