Mastering SQL Server 2017

Enabling Stretch Database by using Transact-SQL

You can enable the Stretch DB feature by using Transact-SQL only. As you saw in the previous section, to enable Stretch DB, you need to create and secure communication infrastructure between our local database and the Azure server. Therefore, you need to accomplish the following three tasks:

1. Create a database master key to protect server credentials
2. Create a database credential
3. Define the Azure server

The following code creates a database master key for the sample database Mila:

USE Mila;   
CREATE MASTER KEY ENCRYPTION BY PASSWORD='<very secure password>'; --you need to put your password here 

Next, we create a credential. This is saved authentication information that is required to connect ...