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.  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.
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.