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
991 stars 342 forks source link

not able to generate error free procedure migration from oracle to postgres #1640

Closed chetan2211 closed 1 year ago

chetan2211 commented 1 year ago

ora2pg -t PROCEDURE -c procedure_migratrion.dist -o procedure_migratrion.sql -l procedure_migratrion_log.sql

I used above command and generate all procedure sql file for postgres. But when i run that sql files it gives some error which i have to find out manullay and resolve. So is there any other way where i can migrate error free procedure using ora2pg or any other tool.

Thanks in advance.

darold commented 1 year ago

Hi @chetan2211, you can have an error free stored procedures migration with Ora2Pg or any other similar tools by using as much possible as standard SQL and compatible statements in your Oracle PL/SQL code, plus the use of the orafce extension in PostgreSQL. Of course this could require rewriting procedures at Oracle side. Choose what you prefer.

chetan2211 commented 1 year ago

Thank you for the quick response @darold. I’ll do it accordingly and will update once it is done.