Cost of full load migration from on prem to azure sql

Amanyire, Arthurnasius A 45 Reputation points

Hello, I have a project i am working on where i have to pull data from 12 different tables and stage it in a single table. The 12 tables are on an on premise sql server database and would like to have the staging table on azure sql database.

I want to do a full load of data from the 12 tables to the staging table that's starting from 1st aug 2023 to date and then after do an incremental load going forward. I am using Azure data factory. How can i achieve this and what are the estimated azure cloud cost seeing the full load is about 70 million rows of data.


Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,004 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,034 questions
{count} votes

Accepted answer
  1. Javier Villegas 635 Reputation points MVP


    Please us below link that explains how to connect Azure Data Factory to SQL Server On-Prem. Consider that you will need to install the Self Host Integration Runtime

    calculate the price is quite tricky so cost will depends on many factors (not onlt the rows you will move)

    use the azure cost calculator as a reference

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful