SQL Azure - copy table between databases

Question

I am trying to run the following SQL:

INSERT INTO Suppliers ( [SupplierID], [CompanyName]) 
Select  [SupplierID], [CompanyName] From [AlexDB]..Suppliers

and got an error "reference to a database and/or server name it is not supported in this version of SQL server"

Any idea how to copy data between databases "inside" the server? I can load data to the client and then back to the server, but this is very slow.

Answer 1

• Create a new data factory

• After deployment of data factory, click on Author and monitor

• Now select copy data

• Mention the source data store as the SQL Data warehouse and import the database which you want to copy, then create a linked service for it.

• Mention the destination data store as the SQL Data warehouse and then create a linked service for it.

• Finally, run the pipeline to copy data from one Azure SQL Data Warehouse to another Azure SQL Data Warehouse.