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

Error when using insert statement in the input file #1657

Closed shiny55 closed 11 months ago

shiny55 commented 1 year ago

Hi, I'm trying to convert input file with oracle queries to postgresql output file. I was able to get table queries by using type as TABLE. but could not convert Insert or Alter queries to respective postgresql.

image

Can you please let me know what all objects can be used with input file option and also which will be the best option to use, input file or connecting to Oracle database to migrate complete data to Postgresql database.

darold commented 11 months ago

Any query, SELECT or INSERT statements should be parsed using the -t QUERY option but parsing INSERT from Ora2Pg should not be parsed correctly, it really depends of the values in the statement.