Trace Id is missing
Skip to main content

SQL Server Stretch Database

Dynamically stretch on-premises SQL Server databases to Azure.

  • Scale SQL Server 2016 using the cloud storage you need

  • Access and query stretched data online

  • Use with advanced security features like Always Encrypted

  • Make warm and cold data available to customers at low cost

  • Move data easily—no query or application changes required

  • Reduce maintenance and storage costs for on-premises data


Make warm and cold data available at a low cost

SQL Server Stretch Database lets you dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Microsoft Azure. Unlike typical cold data storage, your data is always at hand. With Stretch Database, you can provide longer data retention times without breaking the bank. Rather than scaling expensive, on-premises storage, stretch data to the cloud—Azure storage can be up to 40 percent less expensive than adding more enterprise storage. Depending on how often you’ll access the data, choose the appropriate transaction level, and then scale up or down as needed. To learn more, see SQL Server Stretch Database pricing.

Move data without query or application changes

Access SQL Server data if it’s on-premises or stretched to the cloud. You set policy that determines where data is stored and SQL Server moves the data in the background for you. The table is online and ready to query, and you don’t have to change existing queries or applications—it’s completely transparent.

Use advanced security options

With Stretch Database, use SQL Server Always Encrypted to encrypt your data in motion. Row-Level Security and other advanced SQL Server security features also work with Stretch Database, enabling you to extend data to the cloud with greater peace of mind.

Streamline on-premises data maintenance

Reduce on-premises maintenance times and your storage footprint by moving data to Azure. With Stretch Database, backups for your on-premises data run faster and complete more easily than they did on the un-stretched data. Backup is automatic for stretched data, further reducing the amount of time you spend on maintenance.

Manage easily

Turn on Stretch Database from SQL Server Management Studio. Use the Azure portal to configure additional settings and choose a performance level, scaling up or down as needed while keeping control over cost.

Comprehensive security and compliance, built in

A security center overview in Azure showing policy and compliance data and resource security hygiene
The security center compute and apps tab in Azure showing a list of recommendations.

Get started with an Azure free account


Start free. Get USD200 credit to use within 30 days. While you have your credit, get free amounts of many of our most popular services, plus free amounts of 55+ other services that are always free.


After your credit, move to pay as you go to keep building with the same free services. Pay only if you use more than your free monthly amounts.


After 12 months, you'll keep getting 55+ always-free services—and still pay only for what you use beyond your free monthly amounts.

Test SQL Server Stretch Database with your free Azure account