There's a better way to get data out of Azure if you can handle a bit of manual scripting (way worth if for large tables). Setup linked-servers from your local

There's a better way to get data out of Azure if you can handle a bit of manual scripting (way worth if for large tables). Setup linked-servers from your local server (via Server Objects / Linked servers), once you've done that you can just do "INSERT INTO bigtable(..) SELECT .. FROM [remotename].dbo.bigtable;" , it'll tax the transaction log but it's a magnitude faster than bacpac's,etc. Sadly Azure SQL doesn't support linked servers so one of the servers has to be outside.