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.
5,245 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
0 comments
Accepted answer
  1. Nandan Hegde 34,431 Reputation points MVP
    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)
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,301 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

    0 comments

Your answer

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