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

Vijay Kumar 1,996 Reputation points

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?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 27,461 Reputation points MVP

    Try Azure Data Factory Copy Activity. It is really intuitive and easy. as you can see here you can enable parallelism for faster processing.