What are the Pros & Cons of using SQL Azure for existing apps on dedicated servers
- by Mark Redman
We currently own our own servers, and rent a rack in a datacentre.
Looking at the pricing, scalabilty and SLAs for Azure SQL, I am thinking that it might be viable to only use Azure SQL but continue to use our existing applications on our own servers in a datacentres.
This will enable us to not worry about the database and its infrastructure so we can concentrate on building an application server farm with disk storeage for files etc.
Our application is quite big and has various windows services and parts of it used unmanaged libraries that may not be feasible in the cloud, so probably coulnt have everything in the Azure cloud.
The pros:
Reduced Total Cost of ownership (no database servers, no sql server licenses)
The Cons:
I guess there would be overhead in the transfer of data between the Azure Cloud and our datacentre (ie cloud may be in US and datacentre is in the UK) but would this overhead be usable?