Suggest a way to replicate data from on premise sql server 2019 to azure synaspe analytics directly

AGP 40 Reputation points
2024-09-26T14:30:15.38+00:00

Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer

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,378 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,645 questions
SQL Server | Other
{count} votes

Accepted answer
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2024-09-26T14:37:22.33+00:00

    Below blog explains the scenario in detail :

    https://datasharkx.wordpress.com/2022/10/01/event-trigger-data-sync-from-sql-server-to-synapse-via-azure-data-factory-synapse-pipeline/

    where you can create a linked server and trigger the sync


1 additional answer

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 3,300 Reputation points
    2024-09-27T09:40:03.4266667+00:00

    Hi,AGP

    In addition to the pipeline technology of Azure Data Factory, there is another one that I recommend you can try.

    SSIS:Load data into a dedicated SQL pool in Azure Synapse Analytics with SQL Server Integration Services

    This is the official introduction and usage details for pipeline technology:

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

    Regards

    Mikey Qiao


    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

    0 comments No 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.