Summary
Stretch DB allows the moving of historical or less frequently needed data dynamically and transparently to Microsoft Azure. Data is always available and online, and you don't need to change queries in your solutions; SQL Server takes care of the location of data and combines retrieving data from the local server and remote Azure location. Therefore, you can completely delegate your cold data to Azure and reduce storage, maintenance, and implementation costs of an on-premise solution for cold data storage and availability. However, there are many limitations of using Stretch DB and most OLTP tables cannot be stretched to the cloud—at least not without schema and constraint changes. Stretch Database brings maximum benefits to tables with ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
