TrustRadius Insights for Redgate SQL Toolbelt Essentials are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Business Problems Solved
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.
Loading Reviews List....
Reviews
3 Reviews
Professional, Scientific, and Technical ServicesInformation Technology & Services1Marketing & Advertising2
Search is temporarily unavailable. Filters are still applied.
SQL Compare is an integral part of our deployment process. All of our production database deployments go through SQL compare for database objects. We have also used it in one-off scenarios in test or dev servers to save time. We not only use the tool manually but we have also used the SDK for automation. It is very flexible and easy to use.
Pros
UI is very intuitive.
SDK is flexible.
Lightweight and fast. Easily handles hundreds to thousands of objects in a single database.
Cons
UI is a little outdated.
It does automap columns but, when it comes to object renaming it would be nice to have more functionality. We tend to just do renames manually.
Likelihood to Recommend
We have actually been able to use this not only manually but in our DevOps and release process, we have been able to use the SDK to add automation so certain business scenarios we can accomplish with very little effort. We are in an AWS environment with multiple AZs and Active Directories and this tool handles it with no problem. We ensure we have an available endpoint and it is easy to deploy no matter where the DB's are.
I'm a senior software engineer that works on a large web application. My primary use case for Redgate SQL Compare is for comparing schemas between, development, QA, and production databases and for that it works absolutely flawlessly. The ability to choose objects for deployment has also come in very handily in cases where I need to maintain some differences between my environments. I also use the greater suite of Redgate tools and believe the tool belt provides excellent value for myself and the other engineers in our department.
Pros
Allows selecting objects for deployment.
Table and owner mapping is also a nice touch.
Great number of options for customizing the deployment script being generated.
Cons
My tool belt sometimes loses it's license forcing me to fiddle with it to get it working again.
Likelihood to Recommend
I think it's the best schema comparison tool available and it's both fast and customizable.
I use RedGate SQL Compare within my department. In database development, it's an awesome tool to keep database structures and code in sync, especially with there are many hands working on a database. It helps in determining the REAL scope of structure and code migrations. I use it to both generate deployment scripts for later use and documentation and also to effect some migrations immediately. It depends on if I am trying to sync multiple dev dbs or a dev to qc db or from a dev/qc db to a prod db. It is very thorough in its comparisIt's. Its not unusual that I have a few of those "oh I forgot about that change" moments when running it. It saves me lots of time and frustration in performing db change migrations right the first time. I don't ever want to be without it!!
Pros
Deep, thorough SQL Server db comparisons in places you might not think to look.
Gives me flexibility on how I want to save or execute the SQL Compare results.
Remembers settings between uses that speed me in using it.
Has a clear and effective interface.
Cons
Pricing.... I wish there was an inexpensive developer version I could buy for myself.
Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.
Likelihood to Recommend
SQL Compare is great for all database development environments, especially in "wild west," fast paced environments.
