question

ManthanPatel-0811 avatar image
0 Votes"
ManthanPatel-0811 asked OuryBa-MSFT answered

How to migrate from Azure db for Postgres to Azure SQL db?

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?

azure-sql-databaseazure-database-postgresql
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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


0 Votes 0 ·

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.

0 Votes 0 ·

Hi @ManthanPatel-0811 Thanks for getting back . What is the size of your DB and how serious the opportunity?

Regards,
Oury

0 Votes 0 ·
Show more comments
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ManthanPatel-0811 Checking if you had the chance to read the comment above.

Regards,
Oury

0 Votes 0 ·
AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.