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
Reviews
There are no reviews yet.