Azure Database migration service usage for Azure postgres to azure postgres data sync

Geetika Talreja 0 Reputation points
2023-05-11T07:16:28.29+00:00

0

I want to use the Azure database migration service. I have gone through the documentation, but still, I have below questions:

  1. Can I use Azure database migration service for transferring data(incremental load) from one Azure Database Postgres SQL to another Azure Postgres SQL database? (Note:- Both databases reside in their own Azure flexible server. I want to run the flow periodically like once a week.)
  2. Azure offers two types of tiers(Standard and premium). The Standard pricing tier supports offline (also called “one-time”) migrations. Can anybody explain what is offline or one-time migration?
  3. Can I use the standard tier for doing an incremental load every week? I have gone through the documentation but it is not clear to me.
Azure Database Migration service
Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,301 Reputation points
    2023-05-11T10:03:51.7333333+00:00

    Hi Geetika Talreja,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you want to perform incremental data load from one Azure Database Postgres SQL to another Azure Postgres SQL database.

    For this purpose Azure Database Migration Service is not required, instead you can utilize Azure Data Factory for data movement.

    Azure DMS is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime (online migrations).

    However, in your case both resources are on Azure Platform and we have connectors/Linked service for the Database.

    Please refer to the Copy and transform data in Azure Database for PostgreSQL using Azure Data Factory or Synapse Analytics.

    In the above document it is mentioned: Enable incremental extract: Use this option to tell ADF to only process rows that have changed since the last time that the pipeline executed.

    Please go through it and let us know if you have any queries.

    If the answer did not help, please add more context/follow-up question for it, and we will help you out. Else, if the answer helped, please click Accept answer so that it can help others in the community looking for help on similar topics.

    Thank you.

    1 person found this answer helpful.
    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.