Azure synapse link

prasad ch 0 Reputation points
2023-04-20T17:06:28.49+00:00

Can we establish a linked server connection between dedicated sql pool and sql server 2014/2016? if yes, How? give me the proper explanation and answers.

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,281 questions
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.
4,471 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Martin Cairney 2,241 Reputation points
    2023-04-20T20:41:19.1666667+00:00

    Azure Synapse Link is only available for Azure SQL Database or SQL Server 2022. You can however create a connection to you SQL Server 2014/2016 in Azure Data Factory and use that to push your table data into a Synapse Dedicated Pool

    0 comments No comments

  2. Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
    2023-05-01T21:34:08.9266667+00:00

    prasad ch Thank you for reaching out.

    My understanding is that you are trying to establish a linked server connection between dedicated sql pool and sql server 2014/2016.

    In addition to @Martin Cairney answer It is not possible to establish a linked server connection between Azure dedicated SQL pool and SQL Server 2014/2016.

    However, you can use Azure Data Factory or Azure Synapse Pipelines to move data between Azure Synapse Analytics and SQL Server 2014/2016. Azure Data Factory supports a wide range of data sources and destinations, including SQL Server 2014/2016, and can be used to move data between them.

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

    Regards,

    Oury

    0 comments No comments