Request for Assistance in Migrating Azure Cosmos DB for PostgreSQL Cluster Between Subscriptions with Minimal Downtime

Question

We have a requirement to migrate all Azure resources from an Azure Plan subscription to an EA Agreement subscription. Among these resources is an Azure Cosmos DB for PostgreSQL Cluster with a size exceeding 25TB. Unfortunately, Azure Resource Mover does not support moving this resource between subscriptions.

Given the critical nature of the data, the allowable downtime for the migration is less than 3 hours. We understand that Microsoft does not support creating a read replica in another subscription or using a restore point to restore to another subscription.

We have attempted the following methods in a test environment but were unsuccessful:

1. Dump and Restore: Failed due to large data set
2. Replication Slot Approach: Unable to create as there is no replication permission.
3. Logical Replication (PUB-SUB) Approach: We were able to create a publication, but were unable to create a subscription due to lack of "pg_create_subscription" permission.
4. ADF Pipeline Initial Load: Fails at the start when using a distributed table as the source.

Given these constraints, we are seeking guidance on the following:

• Are there any alternative methods to migrate the Azure Cosmos DB for PostgreSQL Cluster between subscriptions with minimal downtime?
• Can any exceptions or special permissions be granted to facilitate this migration?

Any assistance or recommendations would be greatly appreciated.

Thank you for your support.