使用Workbench从MSSQL迁移到MySQL时，无法从源检索架构列表 [英] Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench

问题描述

我正在尝试将MS SQL Server中的数据库迁移到MySQL，我正在使用Workbench进行迁移. 我连接到两个数据库，但收到以下警告:

I'm trying to migrate my database which is in MS SQL Server to MySQL, I'm using Workbench to do so. I get connection to both databases but get the following warning:

Retrieve schema list from source.

这是消息日志:

Starting...
Connect to source DBMS...
- Connecting to source...
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Connecting to Mysql@74.5.3.2:3306...
Connecting to Mysql@74.5.3.2:3306...
Connected
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
WARNING: The following catalogs where not found: Autotask
- Fetching schema names...
- Finished
Retrieve schema list from source finished
Tasks finished with warnings and/or errors, view the logs for details
Finished performing tasks.

自动任务是数据库的名称. 请问我在做什么错了?

Autotask is the name of the db. Please what am I doing wrong?

注意:即使出现警告，向导也会让我单击下一步"，但是下一个屏幕应该列出模式，但由于该页面为空，所以我无法继续.

Note: even with the warning the wizard let me click next, but the next screen is supposed to list schematas, but as it is empty I can't continue.

先谢谢了. 巴勃罗

推荐答案

确保您以"sa"用户身份连接到MS SQL.非管理员用户可能缺少提取架构所需的权限...

Make sure you're connecting to MS SQL as user "sa". Non-admin users may lack rights that are necessary to extract schemas...

这篇关于使用Workbench从MSSQL迁移到MySQL时，无法从源检索架构列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！