尝试使用工作台将Postgresql db迁移到mysql时出错 [英] Error when trying to migrate postgresql db to mysql with workbench

问题描述

我正在尝试按照本教程将Postgresql数据库迁移到mysql: http://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql- workbench-migration-wizard/

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

无法连接到源DBMS [IM002] [Microsoft] [ODBC驱动程序 管理员]未找到数据源名称，也未指定默认驱动程序 (0)(SQLDriverConnect)

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

ODBC连接字符串

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

有人知道如何纠正此错误吗?

Does anyone know how to correct this error?

推荐答案

在我的情况下，我使用的是Windows 64位，并且使用"PostgreSQL ANSI(x64)"确实连接到了Postgres数据库，但是在从Postgres迁移数据库时却出现了错误到Mysql.我使用了驱动程序"PostgreSQL Unicode(x64)"，它可以正常工作.如果您的数据包含Unicode字符，即非ASCII字符，请使用"PostgreSQL Unicode(x64)"驱动程序.

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.

这篇关于尝试使用工作台将Postgresql db迁移到mysql时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！