Some problem in Migrate MySQL database to PostgreSQL using EnterpriseDB Migration Toolkit

202 views Asked by At

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
  1. I want change char type in Mysql to character varying to postgresql ddl;
  2. 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!

0

There are 0 answers