how to connect on-premise database from windows azure

Question

how to connect on-premise database from windows azure

Answer 1

hi balajeed,

Either expose the db on a public ip / dmz or you would need to create virtual network between your on premises and azure deployment

here is a nice post from Brady Gaster about this topic describing in detail the steps, flow and other details

please take a look, hope this helps

-----------------------------------

Please mark as answered if it helped

---

Vishal Narayan Saxena http://twitter.com/vishalishere http://www.ogleogle.com/vishal/

Answer 2

Hi,

You can also use Data Sync to replicate data between on-premises and azure database. Besides, you can use Windows Azure Connect to allow access to your on-premises server.

Best regards,

Susie

Answer 3

isn't Windows Azure Connect retired a long time ago and has been superceded by Virtual Networks already?

Answer 4

Hi,

Thanks for your reminder and sorry for my mistake.

Yes, Windows Azure Connect retired on 7/3/2013 and is no longer operational.

Best regards,

Susie