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.
986 questions
Microsoft 365 and Office | Access | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
    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.