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. Select the correct answer from above options

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.