This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
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 @Manthan Patel 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 @Manthan Patel Thanks for getting back . What is the size of your DB and how serious the opportunity?
Regards,
Oury
The current db size is very small a few GB's, but expected to grow in future. And since we are thinking about migrating to SQL server in future from current postgresql db, but initially we want to migrate to Azure first with minimal efforts or downtime so chosing Azure Postgresql first. And then in near future want to shift to Azure SQL db. But then all of a sudden it clicked me that migrating within Azure env. like from Azure postgresql to Azure sql is something I didnt find any help easily online. So wanted to know if I would have to do this using traditional migration approach like using SSIS or something to load from source to destination transforming data types in between? Or is there a better and easire way to achieve this in Azure?!
Hi @Oury Ba-MSFT , so it seems going through the traditional ETL method is the only way to do this right? I could use SSIS also or have to use ADF only, any idea on that?
Hi @Manthan Patel 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 @Manthan Patel 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