Trying to optimize a copy of table's content between two azure sql databases.
Currently, one DB has an external table setup:
CREATE EXTERNAL TABLE [dbo].[Database2_TableA] ( [Col1] [varchar](100) NULL, [ColN] [varchar](200) NULL ) WITH ( DATA_SOURCE = [Database2], SCHEMA_NAME = N'dbo', OBJECT_NAME = N'TableA' );
Then, inside a stored proc, this statement copies the data
insert into TableA1 select * from Database2_TableA
The table is large (lots of large columns and rows), and the copy takes too long.
Is there more efficient way of doing this?