Hands-On-Lab: Stretch Database

Hello Friends,

Here is another popular lab from Hands-On-Lab library: Stretch Database.

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.

Exercise 1: Create Azure SQL Server, Configure On-Premises SQL Server for Stretch Database
Exercise 2: Move data from On-Premises SQL Server database to Azure using Stretch Database
Exercise 3: Disable Stretch database and get data back from Azure to On-Premises SQL Server

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.