Migrating PostGres Databases Between Instances Using Database Migration Services

Bradley Soverns 0

I am attempting to use the Azure database migration services, but I am experiencing issues when creating the project. I cannot really find the documentation I am looking for or I missed when reviewing the documentation that I found.

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-08-24T18:42:21.5233333+00:00

Hi,@Bradley Soverns Thanks for posting your question in the Microsoft Q&A forum

I'm sorry to hear that you're experiencing issues with creating an Azure Database Migration Services project. Can you please provide more details about the issues you're facing? to better assist you.

https://learn.microsoft.com/en-us/azure/dms/

Regards

Geetha
Bradley Soverns 0 Reputation points

2023-08-25T13:11:56.3466667+00:00

I found another method to accomplish my goal, but I need to push these over to another blob storage location because of a backup size. https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/backup-azure-database-for-postgresql-to-a-blob-storage/ba-p/803343
Bradley Soverns 0 Reputation points

2023-08-25T14:07:41.49+00:00

Can Microsoft provide support to move the Postgres databases to a different instance?
Bradley Soverns 0 Reputation points

2023-08-28T18:04:29.35+00:00

I found a workaround in the migration service. You can close this ticket.

1 answer

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-08-25T15:50:15.84+00:00

@Bradley Soverns Are you talking about logical backups that you take on flex or managed service backups? You cannot move managed service backups as no one has access to them except Microsoft, If it is a logical backup then all best practices that are applicable for moving files to blob will apply here

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

Please let me know if you have any other questions.

Regards

Geetha
Please sign in to rate this answer.
Bradley Soverns 0 Reputation points

2023-08-25T17:30:06.1466667+00:00

No, we have two Postgres instances. An older model and a newer model. We want to move the databases from the old instance over to the new instance. We were going to try to back the databases up; then restore them. To save time I opened the ticket to see if a technician can move the databases for us.

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-08-25T21:17:35.05+00:00

Bradley Soverns I got it now thanks for clarifying and sorry that is not supported here from the community forum. if you are a unified customer then you can work with your CSAM for technical guidance.

https://learn.microsoft.com/en-us/services-hub/unified/roles/services-admin-overview

Regards

Geetha
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Migrating PostGres Databases Between Instances Using Database Migration Services

1 answer

Your answer