Deploying code to Azure, but keeping MSSQL database on dedicated

Question

User1765159799 posted

Hi all,

I would like to put my application code into Azure, but have the database stay on our existing dedicated server where it runs quite well. At the moment the code and database are on the same dedicated box.

I have a connection string that refers to our database server by IP address. This server is behind a firewall. I can punch in an IP address to allow through the firewall. 

Is it possible to obtain details/rules to configure our firewall to allow Azure through?

Is this like anything anyone else has attempted? What is best practice here?

Answer 1

User-1916342745 posted

I think you will find the response times very slow. That said, I can't see any reason why this would not be possible in your case. I have connected an azure website to an old sql server. 

Answer 2

User1765159799 posted

Thanks @romage - how did you do it? Did you use Site-to-Site VPN?

Answer 3

User541108374 posted

Hi,

though possible it'll result in slow performance and also incurs extra costs for bandwidth usage. Only if you make use of SQL Database in the same datacenter as where your services run this cost is eliminated. Also take into account the increase delays of data retrieval.

Grz, Kris.