Share via

Data extraction from Azure VM SQL database onto Azure Sql Database (Elastic pool)

Kirti Rusia 1 Reputation point
2021-01-25T14:45:35.007+00:00

I have readonly Databse on Azure VM (db1)
I have another database on Azure Elastic pool (db2)

I want to extract some table data from db1 on to db2 .

Is there any good process to extract data, without using ETL or managed instance.

SQL Server on Azure Virtual Machines

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. prmanhas-MSFT 17,906 Reputation points Microsoft Employee
    2021-01-27T12:20:29.08+00:00

    @Kirti Rusia Apologies for the delay in response and all the inconvenience caused because of the issue.

    You can make use of Azure Data Factory which is a fully managed cloud-based data integration service that orchestrates and automates the movement and transformation of data. The key concept in the ADF model is pipeline. A pipeline is a logical grouping of Activities, each of which defines the actions to perform on the data contained in Datasets.

    You can read more about it here.

    Hope it helps!!!

    Please "Accept as Answer" if it helped so it can help others in community looking for help on similar topics.

    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.