从Sql server迁移到Mysql workbxnch时出现python module错误

之前上网查教程成功重置了自己Sql server的sa密码，正准备将自己的数据库迁移到mysql上，结果到Migration阶段时就报错：

Starting...
Migrate Selected Objects....

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\workbxnch\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration.py", line 510, in migrate
    self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed


Starting...
Migrate Selected Objects....

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\workbxnch\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration.py", line 510, in migrate
    self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed


Starting...
Migrate Selected Objects....

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\workbxnch\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration.py", line 510, in migrate
    self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed


Starting...
Migrate Selected Objects....

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\workbxnch\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration.py", line 510, in migrate
    self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed


Starting...
Migrate Selected Objects....

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\workbxnch\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "C:\Program Files\MySQL\MySQL Workbxnch 8.0 CE\modules\migration.py", line 510, in migrate
    self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed

只知道看起来是python的某个模块错误，但完全不知道原因在哪以及如何解决，谷歌了半天找不到答案，stackoverflow的解答权也用完了，求解答。

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

报告相同问题？

关注问题

SQL 将 numeric 转换为数据类型 varchar 时出现算术溢出错误。 sql 数据库有问必答
2022-04-09 10:21

回答 2 已采纳 b.Sumcol这个字段值很大吗？
SQLserver2019安装错误：系统找不到指定路径。 sql 有问必答
2021-03-25 09:17

回答 4 已采纳主要是数据库引擎服务方面问题，需重新安装。在安装过程中出现服务器配置窗口时，将数据库引擎服务账户名，改为： NT AUTHORITY\NETWORK SERVICE，运行安装，如不行再改为：NT AU
sqlserver出现大容量加载数据转换错误(截断)。求助？ sql
2021-03-31 08:32

回答 2 已采纳你插入的语句的这个字段的实际值超过10了吧？ L_SHIPMODE CHAR(10) 把你的插入语句或者文件发出来
linux python开发环境sql数据迁移到mysql_Linux下使用Python操作MySQL数据库
2020-12-05 13:12

weixin_39679718的博客安装mysql-python1、下载mysql-python打开终端：cd /usr/local2、解压sudo tar -zxvf MySQL-python-1.2.2.tar.gzcd MySQL-python-1.2.23、在安装前需进行配置a、修改setup_posix.py中的mysql_config.path为你mysql...
sqlserver设置时间为索引，如何操作？ sql sqlserver
2022-03-22 11:35

回答 1 已采纳这种效率太低了还要SQL表设计,直接上代码,CREATE UNIQUE INDEX index_nameON table_name (column_name)
sql server 表名和字段名最大长度限制是？ sql sqlserver 数据库
2022-06-09 12:19

回答 1 已采纳都是128 其余数据库可以参考https://blog.csdn.net/weixin_44231544/article/details/121341519
SQL Server2019在安装时找不到注册表configurationState sql
2020-02-27 18:49

回答 4 已采纳 https://blog.csdn.net/lzqinfen/article/details/38707795 可以用还找不到可以手动新建。
linux python开发环境sql数据迁移到mysql_linux环境下python怎样操作mysql数据库
2020-12-05 13:12

weixin_39719127的博客方法如下：首先在Linux环境下安装mysql-python1、下载mysql-python打开终端：cd /usr/local2、解压636f707962616964757a686964616f31333363373736sudo tar -zxvf MySQL-python-1.2.2.tar.gzcd MySQL-python-...
Eclipse和MySQL数据库连接中出现Module format not recognized eclipse java mysql 有问必答
2021-12-06 16:08

回答 3 已采纳 jar包需要build path添加到项目中。项目下新建一个lib包，将jar包复制到lib包下。选中jar包，build path添加到项目中。
Python用pyodbc访问sqlserver插入数据出错 python sql
2017-05-22 13:11

回答 1 已采纳中文用Unicode编码，然后插入数据库，失败可能是数据库插入有冲突
SQLServer MYSQL Oracle 数据库怎么查看密码策略？ mysql oracle sql
2019-07-18 16:51

回答 1 已采纳数据库貌似没有密码策略一般都是在后台或者前台使用MD5加密加密完存到数据库中吧
Python建表迁移数据错误（ModuleNotFoundError: No module named ‘Crypto‘）
2022-03-23 11:45

鹅纷斐，的博客 #首先运行 ...运行时出现错误：再卸载卸载完之后安装pycryptodome： pip install pycryptodome 安装成功之后，重新运行命令： python manage.py makemigrations 成功， #然后 python manage.py mig
python爬虫爬都到的字符串写入mysql错误 mysql python
2019-04-08 16:26

回答 4 已采纳应该用格式字符串的把，你试试行不行， sql = "insert into ady(score,name,PIC) VALUES ('+%s+','+%s+','+%s+')" %(aa,bb,cc
python flask mysql_python3的flask工程数据库从SQLite迁移到MySQL
2020-12-20 14:31

weixin_39557583的博客 SQLite数据量比较小的时候确实蛮不错的，不过网站的话MySQL还是比较好。SQLAlchemy 数据库引擎能保证工程可以快速切换数据库源。只要切换一下数据库链接就能完成切换，狗书上如是说。既然说那么简单，开始动工切换...
从sqlite 迁移 mysql_seafile从sqlite迁移到mysql
2021-02-05 04:35

Cecilia Zhu的博客 sqlite3.exe下载文件sqlite-shell-win32-x86-3071300.zipFirst make sure the python module for MySQL is installed. On Ubuntu, use sudo apt-get install python-mysqldb to install it.Download these three ...
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 1月18日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
创建了问题 1月10日

悬赏问题

¥15 phython如何实现以下功能？查找同一用户名的消费金额合并—
¥15 孟德尔随机化怎样画共定位分析图
¥18 模拟电路问题解答有偿速度
¥15 CST仿真别人的模型结果仿真结果S参数完全不对
¥15 误删注册表文件致win10无法开启
¥15 请问在阿里云服务器中怎么利用数据库制作网站
¥60 ESP32怎么烧录自启动程序
¥50 html2canvas超出滚动条不显示
¥15 java业务性能问题求解(sql，业务设计相关)
¥15 52810 尾椎c三个a 写蓝牙地址

从Sql server迁移到Mysql workbxnch时出现python module错误

从Sql server迁移到Mysql workbxnch时出现python module错误

0条回答 默认 最新

问题事件

悬赏问题

0条回答默认最新