Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in Azure by (17.6k 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 (47.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!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...