General availability: SQL Server Stretch Database
With SQL Server Stretch Database, you can dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Azure. Unlike typical cold data storage, the data is always at hand. Stretch Database lets you retain data longer and more affordably than typical enterprise storage. Depending on how often the data will be accessed, you can choose the appropriate level of service, and then scale up or down as needed.
Using Stretch Database doesn’t require any application changes. You can also use Stretch Database with new Always Encrypted technology, which helps protect your data at rest and in motion—extending data in a more secured manner for greater peace of mind.