Cross Database query between SQL Server and Azure SQL Database

Sarvesh Pandey 141 Reputation points
2021-10-29T09:21:36.777+00:00

Can we use Cross Database Query to fetch data from Azure SQL Database and running command on On-premise SQL Server.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,351 Reputation points
    2021-10-29T09:47:19.237+00:00

    @Sarvesh Pandey Thank you for reaching out.

    You have 3 options to connect to Azure SQL Database from on-premises SQL Server

    OPENROWSET

    OPENDATASOURCE

    Linked Server

    Please refer to this article on SQL Shack for more details and let us know if you have any questions.

    ----------

    If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.

    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.