How to Copy table from One Azure SQL DB to Another Azure SQL DB

Vijay Kumar 1,996

Hi Guys,

We are planning to copy tables from One Azure SQL DB to Another Azure SQL DB.

The total size of all tables is around 1 TB.

We don't want to copy the entire DB, only a few tables.

I tried with Import/Export and Generate script method doesn't work out as it these are taking hrs together so I canceled the process.

So, My request is what is the fastest way to copy 1 TB?

ShaktiSingh-MSFT 6,961 Reputation points Microsoft Employee

2022-11-21T05:49:28.313+00:00

Hi @Vijay Kumar ,

Just checking in to see if the below answer provided by @Alberto Morillo helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Vijay Kumar 1,996 Reputation points

2022-11-21T19:03:28.59+00:00

Hi @ShaktiSingh-MSFT ,

We have not yet completed testing.

Let you know the status.

1 answer

Alberto Morillo 27,461 Reputation points MVP

2022-11-19T21:10:07.277+00:00

Try Azure Data Factory Copy Activity. It is really intuitive and easy. as you can see here you can enable parallelism for faster processing.
Please sign in to rate this answer.
Vijay Kumar 1,996 Reputation points

2022-11-23T22:54:28.717+00:00

Hi Alberto,

We are still working on ADF for the past 4 days. Meanwhile

I have discussed this solution with my friends and colleagues who are working in different organizations. No positive response. ( everybody is suggesting that
never migrate DB's to Hyperscale until MS provides a solution to reverse Migration)-This is a very bad move.

Looks like this is not a feasible solution

The first thing is configuring ADF is dependent on other teams
Secondly every week we have to refresh db (Around 2TB) from, PROD to an all-lower environment This is very painful.

We opened a case with Microsoft for possibilities of copying DB from Hyperscale to Serverless.
Sign in to comment

Activity