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

Dhwani Anjirwala (Crest Data Systems Private Ltd) 20 Reputation points Microsoft Vendor
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,055 questions
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee
    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.

0 additional answers

Sort by: Most helpful