How to migrate Azure Postgres Flexible Server data to Azure CosmosDB for PostgreSQL cluster?

2023-05-23T12:36:03.4166667+00:00

How to migrate Azure Postgres Flexible Server data to Azure CosmosDB for PostgreSQL?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,892 questions
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
    2023-05-23T20:59:31.0033333+00:00

    Hi, @Dhwani Anjirwala (Crest Data Systems Private Ltd) Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.

    Unfortunately, it’s a Postgres to Postgres migration. I.e. the fact that it’s Flexible Postgres as a source doesn’t change much. 

    The general recommendation is to figure out data modeling first by following the steps outlined here. Once done you would want to create distributed tables on the destination Azure Cosmos DB for PostgreSQL cluster before you ingest (migrate) data.

     For ingesting data, you may want to consider using Azure Data Factory.

    Please let me know if you have any additional questions.

    Regards

    Geetha

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Dhruv kumar 0 Reputation points
    2025-03-20T14:05:48.6233333+00:00

    I had same requirement after searching many articals but found nothing helpful. then I wrote this atrical.

    Check for for migration form PostgreSQL flexible server to cosmos PostgreSQL migration
    https://medium.com/@dhruvkumar1/migrating-postgresql-flexible-server-to-azure-cosmos-db-for-postgresql-19d7f6353a65

    0 comments No 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.