Share via

Cost of full load migration from on prem to azure sql

Amanyire, Arthurnasius A 45 Reputation points
2023-08-26T06:58:05.4166667+00:00

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.

Thanks

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,640 questions
SQL Server | Other
Accepted answer
  1. Javier Villegas 905 Reputation points MVP
    2023-08-26T11:17:20.14+00:00

    Hello

    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

    https://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory

    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

    https://azure.microsoft.com/en-us/pricing/

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.