SQL Server Database can stretch to Azure
- Use limitless cloud storage to expand SQL Server
- Lower costs allow users to continuously use hot and cold data
- Online access and queries can stretch any data
- Effortlessly migrate data - no need to check or alter apps
- Use Premium security functions, including end-to-end encryption
- Lower the cost of on-premises data maintenance and storage
Lower costs allow continuous use of hot and cold data
SQL Server Stretch Database permits you to dynamically stretch hot and cold data in Windows SQL Server 2016 to Azure. Traditional hot data storage is different while your data will be continuously accessible. With the support of Stretch Database, you won’t need to support costly long term data storage. At the same time, you definitely won’t need to expand expensive on-premises storage equipment and can instead stretch data to the cloud. Compared to buying even more enterprise level storage equipment, Azure Storage can help you economize as much as 80% of your cost. You can select your service level based on data access rates and later expand or reduce as needed. For details visit the SQL Server Stretch Database pricing details page.
Effortlessly migrate data - No need to alter apps
Whether on-premises or stretching to the cloud, you can seamlessly access SQL Server data. You can establish policies that determine where data is stored and SQL Server can help you move data in the background. After migration, the whole table will be available anytime online and can be queried anytime. You don’t need to modify your current queries or apps - all of these functions will be completely transparent.
Using Premium security options
If you will have a heavy demand to stretch apps to the cloud, you want to have ample security safeguards. Stretch Database is very secure. You can use the SQL ServerAnytime Encryptionfunction to encrypt data during transmission. Row-Level Security and SQL Server’s other Premium security functions equally apply to the SQL Server Database. You don’t have to worry about expanding your data into the cloud.
Simplify on-premises data maintenance
Moving data into Azure will lower your need for on-premises maintenance and storage capacity. Compared to a non-stretched database, Stretch Database on-premises backup becomes faster and simpler. After stretching, data can be backed-up automatically and this will further reduce the time required for maintenance.
Ease of administration
You can easily start using the Stretch Database from within SQL Server Management Studio. You can use Azure Management Portal to configure other equipment, select performance level, expand or contract on demand, and keep costs under control.