One of the main premises on technological developments, and more at a time like this, is to do the same at a lower cost. The advantages of the databases in the cloud in this regard are clear. And is it possible to obtain significant savings by eliminating the need not only to acquire and maintain infrastructure, but also energy expenditure data center, which represents an important part in organizations of a certain size.
The expected benefits are getting more and more companies bet on Cloud Databases, and if this process the company starting from scratch, there is no major problem. When, on the contrary, we want to migrate to the cloud is a database that already exist locally, this process is of some complexity and implies the need to consider a number of factors to ensure profitability.
In search of ideal scenario
In theory, any database could be migrated to the Cloud environment, the most suitable for this purpose the databases departmental Web Databases or giving access to different stakeholders, both internal and external the organization. A typical scenario for this type of migration could be the Database Development Initiatives Students in education, the bases of small and midsize customers in hosting environments and much more.
In the SQL environment, the natural market for export to the cloud would be Web applications that access SQL Server locally, while in other cases (Windows applications, or other data sources outside the SQL Server database “site “) would require validation and further development, the cost of course, should not exceed the savings expected from migration.
Any migration project Cloud, thus, must be preceded by a feasibility analysis, focusing on three key aspects of DB security, connectivity and performance. The current limitations of the cloud in terms of capacity and performance, are now large corporate databases that need immediate response to hundreds and thousands of users, not the ideal case of migration, which will undoubtedly change in the future . The different cloud providers also have limitations and specific rates depending on the size of the base and transactions per second, so you know our needs will allow us to choose the best price without compromising quality.
It is also important to raise the most appropriate method for sending data, migration, and future capabilities, as in the cloud today is also more difficult to climb. In addition, two other elements must not forget: monitoring the performance of the DB, once migrated, and the creation of a mechanism to reverse migration, if necessary.


