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

Ora2pg Migration assessment using sql file #1709

Closed mgole001 closed 7 months ago

mgole001 commented 7 months ago

Hi

Is there a way to do the migration assessment via Ora2PG without connecting to the source Oracle database?

I have the sql file extracted from the Oracle database (containing procedures, functions, other ddls etc), I want to generate the assessment report in html (show report, estimation) using this sql file as input.

Thanks

darold commented 7 months ago

Yes, import the DDL into a local Oracle database then connect Ora2pg to this local database.

mgole001 commented 7 months ago

Thank you for your response

On Fri, 24 Nov, 2023, 11:02 Gilles Darold, @.***> wrote:

Yes, import the DDL into a local Oracle database then connect Ora2pg to this local database.

— Reply to this email directly, view it on GitHub https://github.com/darold/ora2pg/issues/1709#issuecomment-1825168805, or unsubscribe https://github.com/notifications/unsubscribe-auth/ANM3NY5SOCNRSO46ETZT2P3YGAWPPAVCNFSM6AAAAAA7YS266WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRVGE3DQOBQGU . You are receiving this because you authored the thread.Message ID: @.***>