0

I am trying to migrate from Azure MS SQL to Azure MySQL. I am using the My SQL Workbench to do the migration but the schema list is empty.

I narrowed it down to the problem being the sys.sp_databases system sp returning no results. I have full control over the instance and have tried numerous users including the sqladmin user with no success. I have also tried granting different roles/permissions to see if I can resolve this.

Most suggested solutions says you need VIEW ANY DEFINITION, now on Azure MS SQL that would be "GRANT VIEW DEFINITION TO [User]", I can execute this on the database level but does not change the results of the sys.sp_databases sp. It seems like none of my users, including the full sql admins can grant it on master.

I have also tried assigning the server level roles through

ALTER SERVER ROLE ##MS_DefinitionReader## ADD MEMBER [user]

that according to the documentation is suppose to grant "VIEW ANY DATABASE, VIEW ANY DEFINITION, VIEW ANY SECURITY DEFINITION" but once again, does not make the sys.sp_databases sp come back with results.

Does anyone have any suggestions on what I can do to try and make the sys.sp_databases actually return results on Azure?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
Hein Vermaak
  • 1
  • `sys.databases` will only return details of the database you are connected to and `master` in Azure SQL Databases, as each database is isolated. – Thom A Aug 12 '23 at 09:37
  • Please explain **why** you want to migrate **to** MySQL from MSSQL - that's like migrating from a Ford F-150 to a Ford Fiesta, imo (while Postgres is a Toyota Tacoma...). – Dai Aug 12 '23 at 09:58
  • We want to move mainly to reduce cost, however this is currently more in POC stage to see how much work it would be and what the roadblocks are. – Hein Vermaak Aug 12 '23 at 13:26
  • I'll tell you straight-away that choosing MySQL would very likely be a mistake: Postgres is much closer to SQL Server (in terms of ISO SQL support, features, etc). MySQL stopped being _cool_ at least over a decade ago. – Dai Aug 12 '23 at 17:23

0 Answers0