From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Set up Stretch Database

Set up Stretch Database - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Set up Stretch Database

“

- [Instructor] In this section, we're going to talk about a new feature in Microsoft SQL Server 2016, and it's called Stretch Database. When we stretch a database, it allows us to store some of the data on the local server and some of the data in the Microsoft Azure cloud. We'll need to do a little preparation for this. Your Azure account will need to have access to the namespace Microsoft.SQL. If you've ever used the SQL Azure service, that namespace has probably already been added to your account. If not, you can add access via PowerShell or the Azure CLI. You can download the Azure CLI from Microsoft. Once you've done that, you can open a Command Prompt, type in "azure" and then type in "azure provider register Microsoft.SQL." And when you run that, the provider will be registered, and you'll now have access to the Microsoft.SQL namespace. That should be all you need to do to your Azure account. We'll also need to execute a command on SQL Server, so mere in Management Studio, I'm…

Contents