Overview
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 Compare is great.
Fantastic time saving SQL tool
Redgate SQL Compare -- What's to compare, save time and money!
Very handy tool to quickly see DDL differences between same objects on different databases.
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 …
Redgate SQL Data Compare: a tool every DBA needs in their kit
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 …
Redgate SQL Compare: the only SQL comparison tool you'll ever need!
Save yourself countless hours and headaches when deploying DB changes!!
A must have for DBAs
REDGATE SQL Backup for everyone
It solved our …
RedGate makes awesome SQL Server dev tools!
Pricing
Entry-level set up fee?
- No setup fee
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
Product Details
- About
- Tech Details
- FAQs
What is Redgate SQL Toolbelt Essentials?
Redgate SQL Toolbelt Essentials Video
Redgate SQL Toolbelt Essentials Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(56)Attribute Ratings
Reviews
(1-13 of 13)Redgare SQL Compare saves us time and money
- UI is very intuitive.
- SDK is flexible.
- Lightweight and fast. Easily handles hundreds to thousands of objects in a single database.
- 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.
Redgate SQL Compare is great.
- 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.
- My tool belt sometimes loses it's license forcing me to fiddle with it to get it working again.
Fantastic time saving SQL tool
- Comparison of data
- Deployment of schemas
- Massive time saver
- Honestly I would not change a thing about it
- Deployment of db schemas
- Comparison of data between environments
- Easy creation of SQL scripts
- Allows easy synchronization of databases
- Allows you to easily create deployment scripts.
Years before we did use a source control solution, but that caused more problems than it solved, so I use this software to deploy DB changes from our dev to live platforms. It's more manual, but it gives me the opportunity to review the differences, and from time to time question the choices of the changes!
- It allows you to set up projects for repetitive comparisions.
- It organises object differences very well, with filters and searches available on top.
- Redgate displays the differences between objects very clearly at script level.
- It's created deployment scripts that you can either run yourself, or complete using the application.
- So far so good. I have to be honest, it's not a complicated application, and so far hasn't caused me any issues or to question the choices of the developers!
Very handy tool to quickly see DDL differences between same objects on different databases.
- 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
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.
We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release.
On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.
- 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
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.
Redgate SQL Compare: the only SQL comparison tool you'll ever need!
- 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.
- Extremely fast!
- Compares from source control, not just physical databases. No need to keep copies of databases of varying versions laying around.
- Command line tools integrate easily into automated build processes.
- Even has plugins for products like Octopus Deploy!
- Not the best at initial setups. Sometimes there are error messages that have no bearing on what the problem really is.
- Documentation sometimes can be lacking, but their support team will make up for that.
A must have for DBAs
- Comparison speed
- Immediacy in the highlighting of differences
- Easy to use
- Some features or default preferences are not activated and are a bit hidden between the Options flags
- License fee slightly high
- If you upgrade the SQL server, you need to upgrade the version of SQL
REDGATE SQL Backup for everyone
It solved our business need for solid SQL Server Backups, Retention Policies, and De-duplication via Advanced Compression. It also provided a great Centralized Management of the SQL Server Environment. I would highly recommend it.
- It provided a Great Centralized Management Console. User can go to the Console to manage all of their Redgate Licenses and also configure SQL Server Backups.
- It does an excellent job at managing the SQL Backup and Compressing the backup file to allow for easy transport to DR Locations.
- It has great options for SQL Server Backup Jobs including copying to secondary storage locations.
- Better License Management would be an improvement. Currently no way to manage your licenses without contacting your representative.
- Possibly better testing of backups would an improvement. Ability to restore files in a Sandbox would be a great feature.
RedGate makes awesome SQL Server dev tools!
- 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.
- 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.
- SQL Compare is great for all database development environments, especially in "wild west," fast paced environments.
- Great for SCRUM and Agile.