CODEWITHSUNDEEP
c#azureazure-web-app-serviceazure-sql-databaseazure-data-sync
Matthew Stott
Matthew Stott

Reputation: 397

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...

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.

Upvotes: 1

Views: 550

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15658

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.

Upvotes: 1

Related Questions