How do I migrate a PostgreSQL database from Single Server to Flex Server, change the users to Entra authenticated, and then migrate the database again without users?

Question

I want to migrate a PostgreSQL database from Azure Single Server to Azure Flex Server. Then drop all database users from the Azure Flex Server database and add them back in as Entra authenticated users and set their permissions. Then I want to script off all database user permissions, remigrate the database, drop all users, and apply the Entra scripted users.

Answer 1

Hi Daryl Williams •,

Welcome to Microsoft Q&A forum.

As I understand, you want to migrate a PostgreSQL database from Single Server to Flex Server, change the users to Entra authenticated, and then migrate the database again without users.

Microsoft Entra ID users present on your source server aren't migrated to the target server. To mitigate this limitation, visit Manage Microsoft Entra roles to manually create all Microsoft Entra users on your target server before triggering a migration. If Microsoft Entra users aren't created on target server, migration fail.

The migration service only supports users and roles migration when the source is Azure Database for PostgreSQL single server.

Please refer to https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service for more details.

Thanks.