The Stretch Database feature securely and transparently archives your cold or historical data from a local SQL Server database to Azure SQL Database. This is a new feature in SQL Server 2016. You can either move a complete SQL Server table data from On-Premises SQL Server to Azure OR you can move some specific data based on some criteria from On-Premises SQL Server to Azure SQL Server. This can help in scenario where suppose we have 10 Million of records in On-Premises SQL Server and only 1 Million is widely used, in that case we can move rest 9 Million of records to Azure using Stretch Database functionality. In the first exercise, we will learn to create Azure SQL Server and will also learn to configure On-Premises SQL Server for Stretch Database. In the second exercise, we will learn to move data from On-Premises SQL Server database to Azure using Stretch Database. In the third exercise, we will learn to disable Stretch database and get data back from Azure to On-Premises SQL Server.

Subscribe to Download


Version1.0
Download2
File Size1.88 MB
Create DateMay 15, 2017
Last UpdatedMay 15, 2017