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 343 forks source link

bigint unsigned do not get exported appropriately from MySQL #1651

Closed mrchenwx closed 1 year ago

mrchenwx commented 1 year ago

Hi team, When we export a schema containing unsigned integers from MySQL we observe the following: Sample Schema:

CREATE TABLE big_types ( id SERIAL, big_un_c BIGINT UNSIGNED, big_un_z_c BIGINT UNSIGNED ZEROFILL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8; ora2pg v23.2 ora2pg -m -c /etc/ora2pg/ora2pg.conf -i big_types.sql -o result.sql

Exported Schema: CREATE TABLE big_types ( id SERIAL, big_un_c bigint, big_un_z_c bigint ) ; While the conversion is appropriate for most data types, it does not suffice for int unsigned and bigint unsigned data types. Can we also upscale these data types to use a larger sized integer (or a numeric type in the case of bigint)? Thanks in advance!

image

image

darold commented 1 year ago

This have been fixed in commit 7a78d79.