Queries on On Premises VS Azure cloud VS Synapse

Question

Hi team,

Have below queries, Please provide some inputs . That would be great help.

1. How to move on prime database into dedicated SQL pool.
2. How to move SQL server database into azure SQL database.

Regards,
NagaSri

Answer 1

Hello @NagaSri ,

Thanks for the question and using MS Q&A platform.

Before we go into the answer for which you are looking let understand the integration runtimes available in Azure Data Factory/ Synapse Analytics.

Azure Data Factory offers three types of Integration Runtime (IR), and you should choose the type that best serve the data integration capabilities and network environment needs you're looking for. These three types are:

1. Azure – Helps to connect data sources in Azure Cloud.
2. Self-hosted – Helps to connect data sources from on-premise.
3. Azure-SSIS – Helps to lift and shift existing SSIS workload in Azure

Note: Synapse pipelines currently only support Azure or self-hosted integration runtimes.

For more details, refer to Integration runtime in Azure Data Factory

How to move on-premise database into dedicated SQL pool.

Option1: To get data from on-premise data sources to Azure you can use the SHIR (self-hosted integration runtime).

A self-hosted integration runtime can run copy activities between a cloud data store and a data store in a private network. It also can dispatch transform activities against compute resources in an on-premises network or an Azure virtual network. The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network.

For more details, refer to Copy and transform data in Azure Synapse Analytics by using Azure Data Factory or Synapse pipelines

Option2: You can use Azure Synapse Pathway to migrate from on-premise data warehouse to Synapse dedicated SQL Pool.

For more details, refer to Migrate a data warehouse to a dedicated SQL pool in Azure Synapse Analytics

There is a video which provides more details about Integration with On-Premises Data Sources in Azure Synapse Analytics

How to move SQL server database into azure SQL database.

Option1: To get data from on-premise data sources to Azure you can use the SHIR (self-hosted integration runtime).

For more details, refer to Copy and transform data in Azure SQL Database by using Azure Data Factory or Azure Synapse Analytics

Option2: Migrate SQL Server to Azure SQL Database using DMS

You can use Azure Database Migration Service to migrate the databases from a SQL Server instance to Azure SQL Database.

For more details, refer to Tutorial: Migrate SQL Server to Azure SQL Database using DMS

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators