I understand you must be extremely busy with your new project, so I will just be brief.
I'm trying to convert my MySQL database to PostgreSQL using EnterpriseDB Migration Tool. My setup is as follows:
- Windows 10 x64
- MySQL 5.6.33
- EDB PostgreSQL 10.12
- EnterpriseDB Migration Toolkit 53.0.2
- I want change char type in Mysql to character varying to postgresql ddl;
- And some col in Mysql like userId to postgres, but expected "userId" in pg ddl;
Here is an example in mysql:
create table test
(
testcol char(2),
userId varchar(32)
);
conver by Toolkit:
create table test
(
testcol char(2),
"userId" varchar(32)
);
I expect:
create table test
(
testcol varchar(2),
userid varchar(32)
);
I found command -customColTypeMapping
in docs, but it perhaps not works in my scenario.
So, is there any solutions to resolve this problem. Thanks!