TrustRadius Insights
Redgate SQL Compare has proved to be an invaluable tool for a variety of users in different departments across organizations. Senior …
Starting at $1,209 per year per user (1-4 users)
View PricingOverview
What is Redgate SQL Toolbelt Essentials?
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
Recent Reviews
Pricing
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://www.red-gate.com/products/sql…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $1,209 per year per user (1-4 users)
Product Demos
RedGate SQL Compare Demo
YouTube
Product Details
- About
- Tech Details
- FAQs
What is Redgate SQL Toolbelt Essentials?
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
Redgate SQL Toolbelt Essentials Video
Overview of SQL Compare
Redgate SQL Toolbelt Essentials Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
Redgate SQL Toolbelt Essentials starts at $1209.
Reviewers rate Support Rating highest, with a score of 8.6.
The most common users of Redgate SQL Toolbelt Essentials are from Mid-sized Companies (51-1,000 employees).
Comparisons
Compare with
Reviews and Ratings
(56)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Recommendations
Redgate SQL Compare has proved to be an invaluable tool for a variety of users in different departments across organizations. Senior software engineers rely on it to compare schemas between development, QA, and production databases, and according to their experiences, it works flawlessly. Multiple departments use SQL Compare to identify differences between databases and gather an initial assessment of the database for potential performance issues. The application development team relies on this tool to assist with developing and generating SQL scripts for deployments, while DBAs utilize it for quick and easy comparison of different databases in various environments, including production environments. A small web development team also benefits from Redgate SQL Compare by efficiently managing SQL databases across different environments, eliminating the tedious task of comparing and synchronizing schemas. In addition, Redgate's SQL Compare proves essential in creating upgrade scripts and managing database schema changes for application upgrades and deployments. Overall, the tool is widely appreciated for its ability to synchronize database structures and code, troubleshoot issues by identifying changes in data between two times, and facilitate efficient troubleshooting and issue resolution.
Users have made several recommendations for the Red Gate SQL Compare software. The most common recommendations are:
- Users suggest fine-tuning the functionality in complex systems with foreign key relationships.
- Many users recommend investing in additional tools like Data Compare, Source Control, and SQL Toolbox.
- While some find the license cost expensive, they believe it is worth the price.
Overall, users highlight areas for improvement in complex system functionality while also recognizing the value and benefits provided by the Red Gate SQL Compare software. They suggest enhancing the tool with additional features and tools to further improve its capabilities.
Attribute Ratings
Reviews
(1-5 of 5)Companies can't remove reviews or game the system. Here's why
September 11, 2020
Very handy tool to quickly see DDL differences between same objects on different databases.
Used for code and database object DDL comparison to identify changes.
- Compare DDL in multiple databases or with objects in source code repository
- SQL code comparison in stored procs, views, indexes, triggers or just sql files
- Pick objects to deploy changes from one server to another
- It would be good to have an option to ignore differences changes in comments or blank lines or tabs
- It improves database maintenance efficiency.
Redgate SQL is better.
August 27, 2020
Redgate SQL Compare from the DBA perspective
SQL Compare is being used by multiple departments across the organization. My area, Database Service, uses SQL Compare regularly when we're pulled in to look at performance issues. Since we have several thousand databases with many clients and a custom deployment process that doesn't necessarily deploy all objects exactly the same, we utilize SQL Compare as one of our main tools to look for differences between databases to gather an initial assessment of the database to determine if we may be missing an object, permission or any other database component.
On the application development side, they will use SQL Compare to assist with developing and generating SQL scripts for deployments.
- Ease of use, doesn't require a lot knowledge or experience to use the tool.
- UI is easy to navigate with several options filter content and results are grouped by content which makes comparing differences easy to find. Differences are also color coded and highlighted in code windows so you can pinpoint issues quickly.
- Ability to pick and choose which items you want to sync at a push of a button directly to the database or generate the necessary code snippet needed to deploy to multiple databases using a deployment process.
- Would like more filter options, like just looking for index differences between databases and tables and not seeing all the other differences that may exist in other components like triggers, extended properties, etc.
- A 'Golden Copy', I compare multiple databases that are similar but not exactly the same but you're only can compare 2 databases at a time. I'd like to have the ability to save components from multiple sources to make a golden copy but also have the option to compare the 3 the same time.
- Reduced SLA penalties by identifying missing indexes that caused performance to degrade over time.
- Provides a low cost secondary verification check after release deployments to insure all objects have been deployed successfully.
- Easy to use tools with no additional training overhead to get the most out of the tool.
I've been using Redgate SQL Compare for 15+ years and have no desire or need to look for anything to replace it.
I primarily use Redgate SQL Data Compare when troubleshooting issues to determine what has changed in a database between two times. It is great for ad-hoc troubleshooting, then recovering from the issue.
- Provides many options for setting the comparison key
- Provides flexibility about what you are comparing (database, backup, scripts)
- Makes it easy to filter down to just what you are looking for
- Would be cool if it could read transaction logs to find what caused the change
- Allows me to make better use of my time
- Allows less knowledgeable people to have the ability to provide analysis if I am unavailable
February 08, 2020
SQL Data Compare, not pretty, but it works
- Redgate SQL Compare is used in multiple departments within our organization. My company hadn't used Redgate products previously to my hiring, but it is spreading out through the company.
- One of the challenges working with data, especially in different environments, is finding differences/changes that have occurred in the data. Redgate SQL Compare makes this very easy to accomplish, highlighting the differences and even giving you the option to update the data on one of the systems.
- Data comparison
- Data update
- Speed of execution. It can be slow to run, especially on large datasets.
- It has saved development time
We only looked at Redgate SQL Compare if I recall correctly.
November 01, 2019
Redgate SQL Compare: the only SQL comparison tool you'll ever need!
My small web development team uses Redgate SQL Compare to help us manage our SQL databases across different environments (development, QA, and production, etc.). It eliminates the tedious and manual task of comparing database schemas and synchronizing them and their data across these different environments.
- Simple and easy comparison of database schemas and data. Differences can be copied or synced from one database to another with a click of a button.
- You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
- It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
- I honestly can't think of anything I don't like or anything I would change.
- It's reduced errors and bugs associated with deploying new application features and forgetting to apply required database changes (or incorrectly applying them).
- It's made deploying new features a quicker task, eliminating the often laborious task of synchronizing schemas and data across databases.
- These sometimes complex queries and operations can easily be performed by any developer and don't require the involvement of a database administrator to perform.
I haven't felt the need to try many different products like Redgate.