0 votes
1 view
in Azure by (15.1k points)

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.

1 Answer

0 votes
by (41.2k points)

  • 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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...