Tuesday, June 14, 2016

Stretch your database from Azure Cloud to On premises server

Data need not be something fixed and your hot and cold data can be kept anywhere that makes sense. Of course you need to find which is a less expensive option and which has the priority. Try to consider the pros and cons of putting data on the cloud (energy, bandwidth, server aging; security,etc).

Why do you need this?

Well you want to archive data (historical) but you do not want to store it locally as it is not frequently accessed and your resources are inadequate. However you do want to access. No problem, a query in SSMS can access that data (remotely stored in Azure) as easily as the on premises data. It is possible there may be a bit of latency from the remote site.

Source: MSFT Blog

Wizard takes care of Stretch database

SSMS 2016 has a very good wizard to take care of the Stretch Database.  The Wizard is accessible via the Object Explorer. You need to select the database you want to extend using the Stretch Database feature. It is not necessary that you choose an entire database to extend; you can use the filter to include what you need to go into the Stretch database. Of course, since the remote is on Azure, you should have an account and proper credentials. The Stretch database is always online and querying should have no problem.

How do you enable Stretch Database feature

You need to have an instance of SQL Server 2016. Then just right click the database you want to 'Stretch' and choose the enable option as shown. Just to enable you do not need to be connected to Azure Cloud.


Stretch database is compatible with the other features; Transparent Data Encryption and Always Encrypted and Row-Level Security features.

You do require a Azure account but a free trial is available. There is a price for everything including the new Stretch database feature.

More here:
https://blogs.technet.microsoft.com/dataplatforminsider/2016/04/13/keep-data-virtually-forever-with-stretch-database-in-sql-server-2016/

2 comments:

Unknown said...
This comment has been removed by a blog administrator.
Jeffy said...
This comment has been removed by a blog administrator.
DMCA.com Protection Status