I am currently migrating from postgres on prem to Azure postgres and in future might want to migrate to Azure SQL db from Azure postgresql db. What are the options available for this with minimal effort and downtime?
I am currently migrating from postgres on prem to Azure postgres and in future might want to migrate to Azure SQL db from Azure postgresql db. What are the options available for this with minimal effort and downtime?
Hi @ManthanPatel-0811 Thank you for posting your question on Microsoft Q&A. We are checking with our PG if this can be achievable. You can migrate an Azure PostgreSQL single server to another Azure PostgreSQL online using Online Data Migration Migration.
You can perform PostgreSQL migrations to Azure Database for PostgreSQL with minimal downtime by using the newly introduced continuous sync capability for the Azure Database Migration Service.
Regards,
Oury
Ok thanks, please let me know as migrating within Azure platform (Azure postgres to Azure sql) is what I am looking for but couldn't find anything relevant.
Hi @ManthanPatel-0811 Thanks for getting back . What is the size of your DB and how serious the opportunity?
Regards,
Oury
Hi @ManthanPatel-0811 As from my knowledge I will suggest to use Azure Data factory as a tool to copy your data from Azure PostgreSQL to Azure SQL..
You can also copy data in Azure SQL Database by using Azure Data Factory.
Regards,
Oury
Hi @ManthanPatel-0811 Checking if you had the chance to read the comment above.
Regards,
Oury
A few options to migrate the data and/or business logic on the Postgresql database to Azure SQL Database could be:
1) First option, install SQL Server on-premise on your organization and the SQL Server Integration Services (SSIS) component and use SSIS to extract the data from Postgresql to Azure SQL. Here you will find and example, adapt the example to connect to an Azure SQL Database as destination.
2) Second option, use Azure Data Factory's Copy Activity to copy (migrate) the data from Postgresql to Azure SQL Database. However, you need to configure a self-hosted integration runtime to connect to Postgresql. You can also use the managed virtual network integration runtime feature in Azure Data Factory to access the on-premises network without installing and configuring a self-hosted integration runtime.
3) Use third-party tools like Ispirer that may help you not only migrate the data like options 1) and 2) but also the business logic that resides on triggers and stored procedures
11 people are following this question.