locked
Azure SQL Sync - Cross Tenant RRS feed

  • Question

  • I want to setup a sync scenario where a customer has a copy of my azure database, synced weekly to their azure sql.

    I cannot find any documentation or scenarios to explain how this is done.

    Is it possible, or would i need to use a different approach ?

    The Customer has their own Azure Tenant, and Subscriptions not linked to mine.

    Friday, June 5, 2020 9:00 AM

All replies

  • Azure SQL Data Sync cannot be used across tenants.

    How big is your database? 

    You can export your database to a Storage Account, Az Copy the .bacpac file to a storage account in the other subscription and import from the .bacpac file to create the database in the other subscription.

    You can automate the whole thing with an Azure Function or Powershell

    The process is briefly documented here

    -

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further queries do let us know. 

    Friday, June 5, 2020 11:00 AM
  • Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further queries do let us know. 

    Monday, June 8, 2020 5:50 AM