CODEWITHSUNDEEP
azuresql-server-2016transferazure-synapse
Ardalan Shahgholi
Ardalan Shahgholi

Reputation: 12555

Transfer table data from SQL Server 2016 to Microsoft Azure Synapse

I have an SQL Server 2016 on-Promises with three tables. In total I have over 20,000,000 records. I need to transfer them to Azure Synapse.

I have created ssis packages to transfer data but I am looking for less expensive way to do that. I transferred just 20000 rows and it costed me about 250$.

Is there any tool or solution for that?

enter image description here

Upvotes: 0

Views: 592

Answers (1)

ASH
ASH

Reputation: 20302

Do you have access to Azure Data Factory? If so, use that resource. The link below gives you step by step instructions about how to do everything.

https://marlonribunal.com/copy-data-from-on-premise-sql-server-to-azure-database-using-azure-data-factory/

enter image description here

I've found Data Factory to be very easy to use and pretty darn fast. If you want something more command line driven and super, super, super fast, consider using Azure Databricks for this kind of task. The link below will help you get started with things.

https://www.mssqltips.com/sqlservertip/6151/using-azure-databricks-to-query-azure-sql-database/

enter image description here

Upvotes: 1

Related Questions