Issue migrating azure postgress single to flexible server

Question

Hello communiy,

I am attempting to migrate a modest single database from Azure Postgres to the new Flex instance. The process took approximately three hours and generated the following error:

The error message does not provide any details as to why it occurred. Could you please assist me in resolving this issue?

Answer 1

Hi @MigCrz

Thanks for the question and using MS Q&A platform.

There appears to be an issue with retrieving the migration status from the Azure Database Migration Service. Please follow these steps to troubleshoot the problem:

Please ensure that your source and target servers are able to communicate without any network issues. For assistance with debugging connectivity problems, refer to the network guide.

Make sure that the server configurations, including SSL settings, are correctly set up. Sometimes, SSL configuration errors can cause migration failures.

The migration process may lack the required permissions to retrieve the migration status, so ensure the account used has the proper permissions both on the source and target databases.

If your Azure resources (servers, databases) are experiencing issues (e.g., resource exhaustion, outages), this can prevent the migration process from completing successfully.

Please go through these documentations that might help you:

https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service?source=recommendations

https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes

If the issue persists, it might be best to contact Microsoft Customer Support with the specific error code and details about your setup.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.