question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked OuryBa-MSFT commented

Azure DMA tool for Postgres ?

Whenever we migrate on-premises SQL server to Azure, we use the Azure DMA (data Migration Assistant) Or the DMS
The DMA assessment gives if any migration blockers etc .

If i have to migrate on-premises Postgres DB into Azure Postgres database option, do i have any assessment tool


azure-database-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered OuryBa-MSFT commented

Hi @MSTechie-7364,

The Azure Database Migration Service (DMS) is capable of migrating on-premise PostgreSQL instances to Azure Database for PostgreSQL.

You can use Azure Database Migration Service to migrate the databases from an on-premises PostgreSQL instance to Azure Database for PostgreSQL with minimal downtime.

https://docs.microsoft.com/en-us/azure/dms/tutorial-postgresql-azure-postgresql-online-portal


If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!


Best regards,
Leon

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MSTechie-7364, In addition to @LeonLaude answer ,Also note that the target Azure Database for PostgreSQL version must be equal to or later than the on-premises PostgreSQL version. For example, PostgreSQL 9.6 can migrate to Azure Database for PostgreSQL 9.6, 10, or 11, but not to Azure Database for PostgreSQL 9.5. Migrations to PostgreSQL 13+ are not supported at this time.

Hope that helps
Regards,
Oury

0 Votes 0 ·

@MSTechie-7364 Please let us know if you have additional query.
Regards,
Oury

0 Votes 0 ·

Hi @OuryBa-MSFT

My point is before the migration , we need to assess the compatibility of moving that specific Postgres to Azure Postgres SQL.
For SQL , we have the DMA , which gives us assessment before moving via DMS

Similarly for Postgres, is there any assessment before migrating to Azure Postgres SQL ?

0 Votes 0 ·
Show more comments