Share via

How to copy tables from Azure SQL Database to Azure Data Explorer database without using Data Factory?

Bexy Morgan 260 Reputation points
2023-07-24T11:36:41.6233333+00:00

Is there any way to copy tables from Azure SQL Database to ADX? If not how can I get Azure SQL Database tables into ADX?

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
526 questions
0 comments
Accepted answer
  1. Sander van de Velde | MVP 32,641 Reputation points MVP
    2023-07-24T17:06:05.7333333+00:00

    Hello @Bexy Morgan ,

    you can try this using an external table or an inline SQL query.

    See this blog post for more details.

    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hochgurtel, Brian D 20 Reputation points
    2023-10-03T16:26:02.0566667+00:00

    If you actually want to move data from SQL to ADX, you can look at streaming data with C# into ADX:

    https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-streaming?tabs=azure-portal%2Ccsharp

    https://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats?tabs=c-sharp

    At a high level you would select data from sql, convert it to Json, and then stream into ADX. I used C# to do this.

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