Share via

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

Milly 0 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 SQL Database
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,171 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,432 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,811 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
  2. Nandan Hegde 33,796 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

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.