Azure SQL Server - Best method to copy 20 million rows from one table to another

Question

Hi,

We would like to make a complete copy of one our Azure SQL tables (containing approx 20 million rows). Is there a way to do this without scripting in Management Studio? Last time we attempted to execute such a query the machines running the query crashed around the 100k row mark.

Thanks

Answer 1

Hi @T West , welcome to Microsoft Q&A forum.

There are many ways to do migration from one Azure Database table to another:

1. Using Azure Data Factory
2. Using elastic queries
3. Using Data Sync (Suitable for entire database)
4. Generate Scripts

You can definitely give a try to Azure Data Factory as mentioned in below article:
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal

Please let us know if this helps or we can discuss further on this.

----------

if answer helps, please select 'Accept Answer' as it could help other community members as well.

Answer 2

Thanks @AnuragSharma-MSFT