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

ver 23.2, issue with the column name (table or sequence or index name) having special character as $ #1593

Closed bharanisvng closed 1 year ago

bharanisvng commented 1 year ago

We recently upgraded to ora2pg Ver 23.2. we noticed issue with the column name (table or sequence or index name) having special character as "$" in their name

With the older version of ora2pg , it got converted without any issues.

We faced issued in the conversion of a Sequence name having " $" in their name. CREATE SEQUENCE "public"."bsv_ISEQ$$_25269" MINVALUE 1 MAXVALUE XXXX INCREMENT BY 1 START WITH 142 ;

mkgrgis commented 1 year ago

See https://github.com/darold/ora2pg/issues/1581 https://github.com/darold/ora2pg/pull/1563 https://github.com/darold/ora2pg/issues/1567

darold commented 1 year ago

This have been fixed.

bharanisvng commented 1 year ago

Darold - I believe your fix ( We recently upgraded to ora2pg Ver 23.2. we noticed) is fixed in ora2pg ver 24.0 or the future release ?. can you pl clarify ,

darold commented 1 year ago

I have not made archeoligical research in the commits but when I export such sequence I have the following result:

CREATE SEQUENCE bsv_iseq$$_25269 INCREMENT 10 MINVALUE 10 MAXVALUE 100 START 10 CACHE 2 CYCLE;

or when PRESERVE_CASE is enabled:

CREATE SEQUENCE bsv_iseq$$_25269 INCREMENT 10 MINVALUE 10 MAXVALUE 100 START 10 CACHE 2 CYCLE;

There was lot of fixes in 24.0, you should upgrade or better use latest development code if possible.