Share via

How to stop sql_generate_invisible_primary_key generation when migrating Access database to Azure MySQL

GScavello 0 Reputation points
2024-06-10T21:07:18.86+00:00

After import of Access table to Azure MySQL instance database, an invisible primary key is automatically generated. 'SHOW VARIABLES LIKE "sql_generate_invisible_primary_key";' shows 'ON'. Trying to 'SET GLOBAL sql_generate_invisible_primary_key = OFF;' results in Error Code 1227. The same invisible primary key is automatically generated when using the Table Data Import Wizard from a .csv file as well. Setting sql_generate_invisible_primary_key = OFF results in the same error code. 

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
842 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
398 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee
    2024-06-10T21:47:23.5333333+00:00

    @GScavello Welcome to Microsoft Q&A thanks for posting your question

    Are you trying to OFF from the Azure portal? check the steps from here https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations

    Also refer the document for limitations https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online.

    Can you share more information on how you are migrating.

    Regards

    Geetha

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.