I have database in PostgreSQL. It is simplest possible database with schema presented here:
I want to migrate it to MySQL. I trying to follow after tutorial:
I installed ODBC, but during testing connection I have error:
Could not connect to Source DBMS.
[07006] Received an unsupported type from Postgres. (14) (SQLGetData)
ODBC connection string: DRIVER=PostgreSQL ANSI;SERVER=127.0.0.1;PORT=5432;DATABASE=test;UID=daniel;UseDeclareFetch=1;
My system: Ubuntu 18.
Update 1
I simplified considered schema to single table
CREATE TABLE COMPANY(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL
);
I found similar topic on stackoverflow:
changed driver value to psqlODBC
and problem still exists. I can connect to database from Datagrip without problems.