Share via

copy data from Sql DB on Azure VM to Azure SQLDB

rajanisqldev-42 211 Reputation points
2020-10-08T16:29:01.773+00:00

Hi

I have azure VM and having Sql database on it.

We are moving to Azure environment. I have created Azure SQL DB on Azure subscription.

I need to copy data from SqlDB on VM to Azure SQL DB. This is ONE OFF*

There is around 60GB data. How can I copy this data to Azure SQL DB

Do I need to use ADF? Will it be expensive?

What else other options apart from ADF?

Thanks in advance

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee
    2020-10-09T01:39:02.11+00:00

    @rajanisqldev-42

    ADF is definitely an option if you also want to perform Data Transformation when you migrate your DB. Depending on your choice of Azure SQL DB and Azure SQL DB Managed Instance, there are several ways to achieve the migration.

    Please go through the below documents in detail to check the information:

    1. Azure SQL DB
    2. Azure SQL Managed Instance

    Please go through these and get back to us if any questions

    Thanks
    Navtej S

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.