Error when trying to migrate postgresql db to mysql with workbench

Question

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

I am experiencing this error when I try to test my connection

Could not connect to Source DBMS [IM002][Microsoft][ODBC Driver Manager] Data soure name not found and no default driver specified (0)(SQLDriverConnect)

ODBC connection string

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

Does anyone know how to correct this error?

Yes I already installed psqlodbc driver psqlodbc_09_03_0300.zip from herer: http://www.postgresql.org/ftp/odbc/versions/msi/ — Brooks Fiala, Oct 05 '14 at 03:51
You need to test some: - Check the database accept remote connections over TC, - Check if your password is correct — Ivan Cachicatari, Oct 05 '14 at 04:05
I have checked already, have been struggling with this all day — Brooks Fiala, Oct 05 '14 at 04:14
From deleted answer: The driver names are: `Driver={PostgreSQL ANSI}` (32-bit ANSI codepage), `Driver={PostgreSQL Unicode}` (32-bit UTF-16 Unicode), `Driver={PostgreSQL ANSI(x64)}` (64-bit ANSI codepage), `Driver={PostgreSQL Unicode(x64)}` (64-bit UTF-16 Unicode). — Craig Ringer, Oct 06 '14 at 01:15
@heliotrope in my case both psqlodbc adn psqlODBC does not works. — Daniel, Mar 20 '19 at 09:06

score 10 · Answer 1 · answered Mar 02 '17 at 09:01

10

In my case I was using Windows 64bit and using "PostgreSQL ANSI(x64)" did connect to the Postgres database but it gave errors while migrating the database from Postgres to Mysql. I used the driver "PostgreSQL Unicode(x64)" and it worked. If your data contains unicode characters i.e. non ASCII characters use "PostgreSQL Unicode(x64)" drivers.

answered Mar 02 '17 at 09:01

Javed

5,904
4
46
71

1

PostgreSQL ANSI(x64) did the job for me – MSaudi Sep 15 '18 at 17:04

Niño Bonita · Answer 2 · 2018-10-04T22:58:57.800

4

I encountered the same error. Here is how I solved it:

I downloaded the drivers from https://www.postgresql.org/ftp/odbc/versions/msi/ (Select the most recent one for x64)
In the Overview form, click on the button "Open ODBC Administrator". Add the recently installed "PostgreSQL ANSI(x64)". Click "Finish".
When you "Start Migration", in the source selection form, use "Driver: PostgreSQL ANSI(x64)"

edited Oct 04 '18 at 22:58

answered Oct 04 '18 at 22:44

Niño Bonita

41
2

score 2 · Answer 3 · answered Jun 18 '15 at 05:04

2

Just quoting Craig Ringer's comment to make it "more visible"

If you have Windows 64Bits then you probably had installed only the 64bit psqlodbc drivers, so all you need is to use e.g.: PostgreSQL ANSI(x64) (I had used that and worked for me)

Just stuck onto it for at least 1h until came into Craig's comment, Thanks man!

answered Jun 18 '15 at 05:04

Luiz Eduardo

380
4
13

It is working for me i just changed PostgreSQL ANSI to PostgreSQL ANSI(x64) – Bikesh M Nov 04 '16 at 07:49

score 2 · Answer 4 · answered Oct 16 '17 at 09:56

2

For those on Ubuntu install the postgres ODBC drivers:

apt-get install odbc-postgresql

answered Oct 16 '17 at 09:56

Kris

19,188
9
91
111

score 1 · Answer 5 · answered Jan 02 '19 at 13:35

1

I followed the official documentation from MySQL Workbench, in which they tell you to set up you ODBC connection as

Name: 'psqlODBC'

This is now the name of the driver. So whatever you have called the name in ODBC will need to match your Driver inside Workbench

^{Name psqlODBC}

^{Matches Driver here psqlODBC}

And then hopefully you'll get:

answered Jan 02 '19 at 13:35

Jamie Hutber

26,790
46
179
291

that "name" from Mysql Workbench must be the same as name in ODBC - that was my problem!! Thanks – WBAR Aug 30 '21 at 02:01

score 0 · Answer 6 · edited Dec 09 '19 at 20:49

0

This worked for me (w/ ODBC installed):

Click "Open ODBC Administrator" button
Go to "Drivers" tab
Copy the "Name" Column value from your ODBC and close popup
In tab "Parameters", "Driver" field, Past the "Name" copied
Test connection

edited Dec 09 '19 at 20:49

tshimkus

1,173
2
17
24

answered Dec 09 '19 at 19:39

Ademar Freitas

1

Vimal Mathew · Answer 7 · 2015-01-14T17:38:07.490

-3

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)
This worked for me.

edited Jan 14 '15 at 17:38

answered Jan 14 '15 at 16:53

Vimal Mathew

575
3
10

This does not work. Can you add a little more detail on how this worked for you? How you installed it? What file you downloaded? Version?32 bit? 64bit? Please add more details, I have been struggling on this. – oneofakind Jul 27 '15 at 08:24
same comment as above, this answer is so random – ericn May 24 '16 at 08:34

Error when trying to migrate postgresql db to mysql with workbench

7 Answers7

Linked