Data migration from mysql to postgres is not converting the datatype smallint(mysql) to Boolean(postgres)
Opened this issue · 1 comments
hero78 commented
While migrating from mysql Database to Postgres. The Data type smallint which is meant to capture values like 1,0 (True/false respectively) is failing to be coverted to BOOLEAN. In Postgres it's maintained as Smallint
manakov-dev commented
In my case it was tinyint and adding
"tinyint" : {
"increased_size" : "boolean",
"type" : "boolean",
"mySqlVarLenPgSqlFixedLen" : true
},
to the data_types_map.json helped. But check that you use Smallint only for boolean values before this hack.