Share via

Prevent Automatic Migration of PostgreSQL Single Server to Flexible Server

David Barker 20 Reputation points
2025-03-29T13:41:46.25+00:00

Hi,

Please confirm and ensure that no automatic migration will be attempted for the following PostgreSQL Single Server instance:

We have already completed a manual migration of all databases to a new Flexible Server instance, and do not want Microsoft to retry or reschedule any automatic migration on this server.

There is still a banner showing: “The last migration attempt didn’t work or was cancelled. We’ll reschedule the automatic migration soon.” This should not happen — the server will be decommissioned once validation is complete.

Please confirm no further automated activity will be performed on this server.

Thanks, David

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
0 comments
Accepted answer
  1. Marcin Policht 44,850 Reputation points MVP
    2025-03-29T13:59:51.41+00:00

    Unfortunately this does not appear to be the option. As per https://learn.microsoft.com/en-us/azure/postgresql/migrate/whats-happening-to-postgresql-single-server

    Q. What happens if I do not migrate or my server is not auto migrated by March 28th, 2025??​

    A. Azure Database for PostgreSQL Single Server will be retired on 28 March 2025. To prevent disruptions or service loss, you must migrate to Azure Database for PostgreSQL Flexible Server before this date.

    Key Changes:

    Starting 29 March 2025, you will no longer be able to create new Single Server instances.

    Existing Single Server instances will be automatically migrated to the comparable Flexible Server in a phased manner—regardless of downtime requirements or application compatibility.

    Single Servers using the following features will NOT be automatically migrated and will be deleted in a phased manner, resulting in data loss:

    • Customer Managed Keys(CMK)
      • Deny Public Access set to Yes

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.