Search code examples
c#azureazure-web-app-serviceazure-sql-databaseazure-data-sync

Microsoft Azure Service Bus / Hybrid Connection

I am looking for a solution to solve the below...

I have a SQL db in an on premise server that runs on a LAN locked down to our site only.

I also have a server up on the cloud with a SQL database.

I need to create a process that grabs data from the cloud and inserts it into the on premise server.

So I'm thinking the below...

  • Create an Azure web app
  • Create a hybrid connection in above web app to connect to on premise
  • Create service bus in azure to facilitate the above.

The web app will just be a script in c# pushing data from one place to the other.

What do you think? Is this feasible? Also need it to be cost effective.

Solution

  • You can use SQL Data Sync to keep your on-premise SQL and your Azure SQL Database synchronized, this way you don't need to create an Azure Web App and you don't need to use Service Bus. The synchronization can be set bi-directional or on one direction (cloud to on-premise). To get started with Azure SQL Data Sync please follow instructions on this documentation.