Share via

How to migrate Dedicated SQL Pool database from cloud to onprem SQL Server 2019

Milly 20 Reputation points
2025-02-07T02:48:54.7433333+00:00

Hi, i have a 128 gb Dedicated SQL Pool in Azure and want to create a copy of the database (or the data) to an on-prem SQL Server 2019, what tools are available to achieve this?

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
2025-02-07T06:16:50.37+00:00

There are multiple ways how you can sync data between dedicated pool to a SQL server 2019 :

  1. Create a linked server in SQL server 2019 connecting to the dedicated sql pool. And then have a SQL server job to copy data from Dedicated pool table into SQL server 2019 . Though this wont be good performance wise
  2. You can use ADF/synapse pipelines copy activity to copy from dedicated pool to SQL server leveraging a self hosted IR ( the server hosting the SHIR needs to have good config for better performance)

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,621 Reputation points
    2025-02-07T06:02:41.4133333+00:00

    You can use SSIS = "SQL Server Integration Services" to copy over data, see

    https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.