Error trying to migrate postgresql db to mysql using workbench

Question

I am trying to migrate the postgresql database to mysql following this guide: http://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-migration-wizard /

I experience this error when I try to test my connection

Failed to connect to the original DBMS [IM002] [Microsoft] [ODBC Manager driver] Data file name was not found and the specified driver was not specified by default (0) (SQLDriverConnect)

ODBC Connection String

Driver=psqlodc;SERVER=127.0.0.1;PORT=5432;DATA... 

Does anyone know how to fix this error?

Answer 1

In my case, I used Windows 64bit and using "PostgreSQL ANSI (x64)" connected to the Postgres database, but it gave errors when migrating the database from Postgres to Mysql. I used the "PostgreSQL Unicode (x64)" driver and it worked. If your data contains Unicode characters, that is, characters without ASCII characters use the PostgreSQL Unicode (x64) drivers.

Answer 2

Just quoting Craig Ringer’s comment to make it “more visible”

If you have Windows 64Bits, you probably only installed 64-bit psqlodbc drivers, so all you need to use is for example: PostgreSQL ANSI(x64) (I used this and worked for me)

Just stuck on it for at least 1 hour until Craig's comment appeared, thanks man!

Answer 3

For those on Ubuntu installing the ODBC postgres drivers:

 apt-get install odbc-postgresql 

Answer 4

Download and install the MSI package for psqlODBC from http://www.postgresql.org/ftp/odbc/versions/msi/ .

Then connect using the following settings
Driver: PostgreSQL ANSI
Connection Method: ODBC (manually entered parameters)
It worked for me.