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

Include validation count for public procedural code within Packages - Oracle_PostgreSQL. #1730

Open dcgadmin opened 5 months ago

dcgadmin commented 5 months ago

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 Oracle with what is available in schema in PostgreSQL.

[TEST PACKAGE FUNCTION COUNT] ORACLEDB:PCK1:1 POSTGRES:pck1:0 ORACLEDB:PCK2:1 POSTGRES:pck2:0 [ERRORS PACKAGE FUNCTION COUNT] DIFF: Function pck1.dummy is missing in PostgreSQL database. DIFF: Function pck2.dummy is missing in PostgreSQL database.