Question 108154 in Azure Question posted in
The official documentation to get you started can be found here.

Cross Database Insert in Azure?

Is it possible for me to insert some data from one database to another in Azure sql?

Let’s say I have a trigger in db1 that updates some values in db2.

I read about elastic queries but it seems like they are read-only so they don’t solve my problem.

Tags:

2

Answers


  1. 0

    There was some previous discussion here about doing similar:

    C# Azure Function trigger when SQL Database has a new row added without polling

    There is also the Azure SQL Bindings for Azure Functions but they are input bindings and not triggers and they’re still in preview and limited to C#, JavaScript and Python.

    Azure SQL bindings for Azure Functions overview (preview)

    There was a new announcement last week after MS Build however for Azure SQL Database External REST Endpoints Integration (hopefully they don’t refer to it as ASDEREI) but this is currently in preview under Early Adoption Program (EAP).

    Announcing the “Azure SQL Database External REST Endpoints Integration” Early Adoption Program

    Login or Signup to reply.
  2. 0

    You can’t use cross-database in Azure Sql Server because databases can’t see eachother physically , you could use elastic pools but they are Read Only.
    A solution is to use SQL Managed Instance to upload your instance . This supports cross-database queries but it was expensive.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search