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
{count} votes

1 answer

Sort by: Most helpful
  1. prmanhas-MSFT 17,891 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 No comments