CODEWITHSUNDEEP
sql-serverazureazureservicebus
chandrika chetty
chandrika chetty

Reputation: 3

Need to select best Azure service to access on-premises sql database

I have a business scenario where web site and SQL database will be on cloud and after some operations want to save the cloud SQL data to the SQL database which is on-premises and not exposed to the internet.

What would be the best architecture for this scenario?

Need suggestions.

Upvotes: 0

Views: 518

Answers (2)

JuneT
JuneT

Reputation: 7860

you can either setup a VNET to connect your Website to your on-premises SQL Server or you can configure Azure Hybrid Connect. (see this link)

Upvotes: 1

Aravind
Aravind

Reputation: 4173

If the website does not use local resources you can always go for azure websites. Choose the tier based on the requirement.

As far as the database is concerned you choose azure sql database. ( tier based on requirement-size and performance) . You can set up azure sql sync (in preview) to sync between sql azure and local sql server. Or you can take a back up of sql azure db - bacpac. and then restore it local sql server using sql management studio.

Upvotes: 0

Related Questions