# Azure SQL Server Stretch Database Reviews **Vendor:** Microsoft **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.1/5.0 **Total Reviews:** 17 ## About Azure SQL Server Stretch Database Azure SQL Server Stretch Database was a feature introduced in SQL Server 2016 that allowed organizations to dynamically extend their on-premises databases to Azure, enabling seamless access to both hot and cold data without significant changes to existing applications. This capability provided virtually unlimited storage and compute capacity, facilitating efficient management of large datasets. Key Features and Functionality: - Dynamic Data Stretching: Automatically migrate cold or infrequently accessed data from on-premises SQL Server databases to Azure, while keeping hot data on-premises for optimal performance. - Transparent Query Processing: Execute queries across both on-premises and Azure-stored data without modifying existing applications, as the process is transparent to users. - Integrated Security: Utilize Always Encrypted technology to ensure that sensitive data is encrypted before being transferred to Azure, with encryption keys remaining on-premises. - Scalability: Leverage Azure's scalable storage and compute resources to manage growing data volumes without the need for significant infrastructure investments. Primary Value and User Solutions: Azure SQL Server Stretch Database addressed the challenges of managing large and growing datasets by providing a cost-effective solution for archiving cold data without compromising accessibility. It enabled organizations to maintain compliance with data retention policies and regulatory requirements by keeping data online and readily available. By offloading cold data to Azure, businesses could optimize on-premises storage and compute resources, leading to improved performance and reduced maintenance costs. However, it's important to note that Microsoft announced the deprecation of the SQL Server Stretch Database feature in SQL Server 2022, with the supporting Azure service retired as of July 9, 2024. Organizations are advised to explore alternative solutions for managing cold data, such as utilizing the CREATE EXTERNAL TABLE AS SELECT (CETaS) feature in SQL Server 2022, which allows archiving data to Azure Storage in Parquet format for cost-effective storage and analytics. ## Azure SQL Server Stretch Database Pros & Cons **What users like:** - Users value the **seamless performance** of Azure SQL Server Stretch Database, especially in large enterprise environments. (1 reviews) - Users praise the **solution efficiency** of Azure SQL Server Stretch Database, appreciating its seamless operation for large enterprises. (1 reviews) **What users dislike:** - Users experience **poor customer support** , leading to frustration and unresolved issues with Azure SQL Server Stretch Database. (1 reviews) ## Azure SQL Server Stretch Database Reviews ### 1. Excellent **Rating:** 4.5/5.0 stars **Reviewed by:** Jenika D. | Workday Senior Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** January 24, 2025 **What do you like best about Azure SQL Server Stretch Database?** The services provided were good and the software is seamless and works well for large enterprises **What do you dislike about Azure SQL Server Stretch Database?** It is somewhere not good in support services. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** It provides secured and reliable data storage that gives user multiple and fast data access.also it is benificial to reduce data maar costs. ### 2. Azure SQL Server Stretch Database: The only tool you will need to effectively manage your Data **Rating:** 5.0/5.0 stars **Reviewed by:** Aditya P. | Associate Content Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** June 04, 2022 **What do you like best about Azure SQL Server Stretch Database?** The main advantage of this application is that it can work with large datasets and has many inbuilt functions like dividing the data into cold and warm categories which help to optimize cost. Another best feature I like about this application is the ease of migration and easy management of the console. **What do you dislike about Azure SQL Server Stretch Database?** The only thing which I dislike the most about this application is that, whenever we have any problem with the tool, it gets hard to reach out to the support team as we have to write an email to reach them. Instead, they can introduce Chatbot for a quick resolution. **Recommendations to others considering Azure SQL Server Stretch Database:** This can be very good for medium-sized businesses, but small-sized businesses might find it a bit costly. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** It has helped my organization in managing the organizational data very efficiently and cost-effectively without any hassles of migration as it provides seamless service. ### 3. Best tool to manage data **Rating:** 4.5/5.0 stars **Reviewed by:** Appa E. | Software engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** June 19, 2022 **What do you like best about Azure SQL Server Stretch Database?** The option behind using this tool is that it has advanced security options, a good dashboard and we can move our existing data without any application changes also we don't need to change existing queries, **What do you dislike about Azure SQL Server Stretch Database?** Pricing should be lower so small businesses can afford it, need to provide a short training video otherwise it is a good tool to choose for data management. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** It was too difficult to move our existing data into an application, we have to make some changes in our application before using it, but this tool helps us to move data without any changes, easy to manage. ### 4. Azure SQL Server Strech Database **Rating:** 3.5/5.0 stars **Reviewed by:** Dilraj S. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Azure SQL Server Stretch Database?** Pretty easy to navigate around different options. **What do you dislike about Azure SQL Server Stretch Database?** Does not give suggestions to do for databases and queries. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** Wrote queries to get data out of a database to debugg data issues and/or update/create tables and columns. ### 5. Azure SQL Server Stretch Database Review **Rating:** 4.5/5.0 stars **Reviewed by:** Prateek J. | DevSecOps Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** January 06, 2022 **What do you like best about Azure SQL Server Stretch Database?** 1. Can divide data into warm and cold categories to optimize cost 2. Migration can be done without changing anything in the application 3. Easy to manage from the console **What do you dislike about Azure SQL Server Stretch Database?** 1. Quite expensive for small businesses 2. Doesn't have great support and documentation **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** I came across a requirement to move data of one of our clients to Azure Cloud, the only available option was SQL Server Stretch Database. It's a bit expensive but the service is seamless. ### 6. Great business tool for large database locations **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** December 28, 2021 **What do you like best about Azure SQL Server Stretch Database?** I had limited engagement with this tool, but we did use it to move items to cloud storage and to allow access of data to customers with that need. **What do you dislike about Azure SQL Server Stretch Database?** This product is pretty massive in its capability, and I could not use all of its features within my position. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** We used it to make cloud storage transfers, as well as to make old data available to researchers in need of longitudinal data. ### 7. Good cloud platform for database management . **Rating:** 4.0/5.0 stars **Reviewed by:** VIPIN Y. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 17, 2021 **What do you like best about Azure SQL Server Stretch Database?** This application works well even for large datasets. It is easy to use and a cloud platform. It has a huge number of inbuilt functions. **What do you dislike about Azure SQL Server Stretch Database?** Nothing. But if you are stuck somewhere you want to help from the support system of Microsoft. Then you have to write a mail they can improve this means some bot etc. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** I was using this to the analysis of the large review data and store, filter them and also used to predict new markets demand for the particular software. ### 8. Less time, less worry using SQL Server Stretch Database **Rating:** 5.0/5.0 stars **Reviewed by:** Alexander M H. | Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** October 13, 2020 **What do you like best about Azure SQL Server Stretch Database?** What I like best is that this program puts efficiency at your fingertips. In the database indstry, we know that queries being able to run like clockwork is the nature of our business. That's what this program was created for. **What do you dislike about Azure SQL Server Stretch Database?** A couple things jump out at me when I think of what I dislike. One is the support around M.S. products. I don't like dealing with people through emails. I've found it tedious and taxing to try to get even the most basic questions answered from M.S. There have been times where I've explicitly told a support rep to not email me but rather call me and they still don't call me. I don't really like the cost layout either. For a small business, it makes the program cost-prohibitive. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** I like what the program does. It basically isolates the data that you're running the query on so that only that data is taking up space in the database. That makes everything run smoother and quicker. ### 9. Data Management **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 03, 2021 **What do you like best about Azure SQL Server Stretch Database?** Easy to use SQL like statements and connectivity in Apache spark using jdbc for data writing after transformation/analytics and power bi access easy in azure environment. **What do you dislike about Azure SQL Server Stretch Database?** SQL Server instance is costly for small business people, it makes the program cost-prohibitive and it supports only for windows machines not supported in Linux based systems. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** All big data analytics/transformed business required data will be stored in SQL Server for reporting using Power BI. ### 10. Good Solution For Database Management **Rating:** 4.0/5.0 stars **Reviewed by:** zahit B. | BI & DWH Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** November 17, 2019 **What do you like best about Azure SQL Server Stretch Database?** MS Sql Server is a strong application to manage the databases on production system. Its easy to use and cross platform tool. Connectivity on different application is very simple. Its performance and response is effective. This application has a large number of inbuilt functions using that database development task becomes easy. We can with ease create new database objects like Table, View, Stored Procedure, Cursor, Indexing etc. Stored procedure execution and tracing is good enough. Using trace we can easily debug the SQL server requests and processing time. **What do you dislike about Azure SQL Server Stretch Database?** It works perfect on Windows OS, but not for Unix or Linux. Query performance is slower than oracle. He needs to create a competitor for Exadata. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** Our organisation supply services to our customers via our web & application development. For back end, we use SQL Server. it helps in our organization to store our back end data. ### 11. Learning A New Tool...It Great! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Enterprise (> 1000 emp.) **Reviewed Date:** April 19, 2019 **What do you like best about Azure SQL Server Stretch Database?** This program has a good dashboard. things are easy to locate but unfortunately that is where it ends. The one thing that Azure does provide is that it allows my organization to share its physical resources with all 14 of our Divisions across one County (different locations). **What do you dislike about Azure SQL Server Stretch Database?** Most software/programs in this field are similar and if you can use one, you can use them all. That is not the case with this software/program. I'd recommend that anyone who will be using this get some kind of formal training or at least watch a video on YouTube. It is not the most user-friendly program. **Recommendations to others considering Azure SQL Server Stretch Database:** Be sure to get formal training. This software is unlike any other. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** Azure SQL Server Stretch Database allows my organization to host data that meets a specific criteria in Azure, and keep it online and accessible without the need for code change. ### 12. Storing data efficiently in the cloud **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 20, 2019 **What do you like best about Azure SQL Server Stretch Database?** Love the ability to utilize this software for moving “cold” data to the cloud because it’s hard to store so much data on premise without making changes to any existing queries or views. Using this software allows us to report off of millions of records of historical and current data records when looking to analyze future trends. **What do you dislike about Azure SQL Server Stretch Database?** The biggest problem with this solution is the cost. It’s great for smaller companies looking to store historical data in the cloud, however may not be feasible for larger companies. **Recommendations to others considering Azure SQL Server Stretch Database:** I would recommend this product to a smaller company who has the means to spend the money moving their data to the cloud. It does help with querying data quickly and doesn't make you change any queries or current views you use on premise! **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** This software has helped us store tons of historical data and centralize our data in the cloud by using a SQL server that doesn’t make us change any existing applications or queries we use on a daily basis. It’s simple to pull data from and extremely fast. ### 13. Azure SQL Server Stretch **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2019 **What do you like best about Azure SQL Server Stretch Database?** Neat and easy to use tool to connect on premise database to cloud database for easy access without any need for gateways. Helps in querying faster and easy access. **What do you dislike about Azure SQL Server Stretch Database?** Time taken is high sometimes but its acceptable. Can maybe improve with some kind of cache implementation with some data taken and persisted to the cloud. Also, this feature requires SQL 16 or above hence all legacy servers have to be updated to use this feature. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** Querying data from on premise client database and pulling it to cloud. ### 14. I recommend Azure SQL Server Stretch Database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Small-Business (50 or fewer emp.) **Reviewed Date:** March 15, 2019 **What do you like best about Azure SQL Server Stretch Database?** Azure SQL Server Stretch Database is an excellent way to make cold data readily accessible. It has an easy-to-use interface that makes it easy for new users (like myself) to quickly get a grasp of the product. **What do you dislike about Azure SQL Server Stretch Database?** To be honest, I can't think of many improvements for Azure SQL Server Stretch Database. Sometimes it runs slowly, but that's all. **Recommendations to others considering Azure SQL Server Stretch Database:** Use it without hesitation. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** Azure SQL Server Stretch Database has solved our issue of requiring a vast amount data storage. With this product we can now easily access cold data. ### 15. sql server for medical data **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** March 12, 2019 **What do you like best about Azure SQL Server Stretch Database?** Easy to use. SQL is very intuitive. Picking up how to use and interface with SQL is very simple. This makes it easy for people in healthcare to understand what went into the capturing of the data. **What do you dislike about Azure SQL Server Stretch Database?** Nothing major. Maybe the color scheme but honestly that's not a major concern. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** We are just pulling demographic information from data sets. Using them to answer clinical questions. ### 16. Great experience **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** April 23, 2019 **What do you like best about Azure SQL Server Stretch Database?** Simplicity, reliability and performance in handling the data consolidations and analytic reporting needs **What do you dislike about Azure SQL Server Stretch Database?** Scalability for very large volumes is an issue and also if it can be used for large user quesires **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** We have used it for Data curation, consolidation and reporting ### 17. A wonderful cloud platform **Rating:** 4.0/5.0 stars **Reviewed by:** Obumneme O. | Application Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 20, 2018 **What do you like best about Azure SQL Server Stretch Database?** We are using Azure for our system in Nigeria. The cloud solution help us to get better performance for all of our customer across Nigeria. With .Net Core and all the feature avalaible to us, We are making better system for our customers. Evidently, Azure SQL server is wonderful **What do you dislike about Azure SQL Server Stretch Database?** Azure is costly and maybe not suitable for the small system but can be great for startup if you can afford it Overall, it is a wonderful platform. **Recommendations to others considering Azure SQL Server Stretch Database:** Any startup that can afford Azure server shouldn't hesitate to do so. **What problems is Azure SQL Server Stretch Database solving and how is that benefiting you?** It has helped us to get a better performance for our customers. ## Azure SQL Server Stretch Database Discussions - [What is a similar product? Who are its' competitors?](https://www.g2.com/discussions/32519-what-is-a-similar-product-who-are-its-competitors) - 1 comment, 1 upvote - [What is stretch database in SQL Server?](https://www.g2.com/discussions/what-is-stretch-database-in-sql-server) - 1 comment - [View Azure SQL Server Stretch Database pricing details and edition comparison](https://www.g2.com/products/azure-sql-server-stretch-database/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-08+14%3A27%3A00+-0500&secure%5Bsession_id%5D=d2dda67a-c2b8-473c-8a68-feb70f274c4a&secure%5Btoken%5D=40cb691cd2e14b15f4236c35f5177fc0990400e52a1ba4ccdefee33b178eb1d0&format=llm_user) ## Azure SQL Server Stretch Database Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top Azure SQL Server Stretch Database Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (706 reviews) - [Toad For Oracle](https://www.g2.com/products/quest-software-toad-for-oracle/reviews) - 4.4/5.0 (281 reviews) - [SAS Viya](https://www.g2.com/products/sas-sas-viya/reviews) - 4.3/5.0 (757 reviews)