In the last few years there has been a lot of hullabaloo on housing your RDBMS and mission critical business data on the Cloud or using a database which is driven by a database engine on the cloud. Although most of the business have desisted from making a major shift to any cloud based data architecture and storage, the prospect of this new technology garnering a sizeable share in the relational database usage is not a distant possibility.
These cloud based data services allows businesses to rapidly create, scale and extend applications into the cloud and relieve themselves from the expensive tasks of maintaining servers, infrastructure and other resources needed for their maintenance.
Today, we will talk about two popular cloud based data services which can be used to host SQL Server databases on the cloud and the pros and cons of these services with respect to each other.
1) Amazon Relational Data Service (Amazon RDS)
A recent entrant into the cloud based data services market, Amazon RDS, in a short frame of time has been able to generate considerable interest and establish itself as one of the major players in this segment. This service supports various RDBMS like ORACLE, MySQL and Microsoft SQL Server database engines on the cloud, allowing businesses to concentrate their focus on applications and core area. Most of the full features and capabilities of a relational database are available on the cloud. Coupled with the option to migrate the existing applications and the tools to work with them, the Amazon RDS service offers a viable and cost effective proposal to the companies.
2) SQL Database (formerly known as Microsoft SQL Azure)
SQL Database, a cloud based database service from Microsoft was one of the first products introduced in the data services market. This product is tightly tied to Microsoft SQL Server RDBMS engine and the features supported by the stand-alone product are available on the cloud.
It will be interesting to see how these two services fare against each other in the future and what other alternatives become available for cloud data services, but if the initial indicators are anything to go by, Cloud data services are here to stay and change the way data is stored, retrieved and used for business!!
For more information on these services, please visit: