尝试迁移数据库时看不到架构 [英] Cannot see schema when trying to migrate database

问题描述

大家好

将mssql迁移到mysql以在开源上测试我的应用程序...无论我给出什么特权我与i连接的帐户无法从mysql工作台访问数据库模式。

Migrating mssql to mysql to test my application on open source... no matter what privileges i give the account i am connection with i cannot access the database schema from mysql work bench.

我确保该帐户只能访问数据库，使用连接，选择和视图定义，以便我可以看到迁移我的架构和数据，但由于某种原因，迁移的架构部分始终为空。我以前做了很多迁移，虽然
从来没有使用Azure sql server而且总是只是本地sql server，它就像魅力一样。

I ensured that the account had access to only the database, with connect, select, and view definition so i can see a migrate my schema and data, but for some reason the schema portion of the migration is always blank. Ive done many migrations before, albeit never with Azure sql server and always just on-prem sql server, and its worked like a charm.

任何想法可能缺少什么权限？

Any ideas what permissions im possibly missing?

Michael M

Michael M

推荐答案

Hello Michael，

Hello Michael,

您能否详细说明您的设置。

Could you please elaborate your set up.

您使用哪个工具连接到Azure SQL for迁移？

Which tool are you using to connect to Azure SQL for migration?

您使用的是哪种身份验证？ - SQL，AD auth等 

What authentication are you using? - SQL, AD auth etc. 

这篇关于尝试迁移数据库时看不到架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！