CODEWITHSUNDEEP
azure-sql-database
Jon Leach
Jon Leach

Reputation: 871

How to insert data from one Azure SQL Database into a different Azure SQL Database?

I realize that Azure SQL Database does not support doing an insert/select from one db into another, even if they're on the same server. We receive data files from clients and we process and load them into a "load database". Once the load is complete, based upon various rules, we then move the data into a production database of which there are about 20, all clones of each other (the data only goes into one of the databases).

Looking for a solution that will allow us to move the data. There can be 500,000 records in a load file and so moving them one by one is not really feasible.

Upvotes: 1

Views: 752

Answers (1)

Silvia Doomra
Silvia Doomra

Reputation: 953

Have you tried Elastic Query? Here is the Getting Started guide for it. Currently you cannot perform remote writes, but you can always read data from remote tables.

Hope this helps!

Silvia Doomra

Upvotes: 2

Related Questions