Redgate offers end-to-end Database DevOps to help organizations streamline software development and get value from their data faster. Our solutions enable IT leaders, development, and operations teams to increase efficiency, reduce errors, and safeguard business-critical data. Redgate’s portfolio of solutions helps organizations reliably solve the complex challenges of database management across the DevOps lifecycle on any database, anywhere. Our enterprise-grade suite delivers solutions for testing, deployment, automation, and monitoring, fostering reliability and security for rapid software delivery. With 25 years’ experience, Redgate understands the complexity that today's database architects, administrators and developers face and works closely with our customers to help them solve their large-scale data problems and deliver innovation faster. More than 200,000 people globally trust Redgate to deliver ingeniously simple software.
Do You Manage Peer Insights at Redgate Software?
Access Vendor Portal to update and manage your profile.
For many years, our schema deployment pipeline has depended upon: (a) SQL Source Control, to get well-formed schema changes submitted to Github for review, (b) SQL Compare, to build a unified delta script of schema changes to be deployed in the next release, and (c) SQL Multiscript, which handles my edge case One to Many schema deployments, where the same delta script gets applied to upwards of 10,000 databases in a fast and orderly fashion.
It works great for SQL Server data migration.
SQL Search to find text inside a stored procedure or any object saves a lot of time, SQL Source Control helps in tracking changes - vital and SQL Prompt helping in writing codes faster
Dislike is far too strong a word here. Would I like out-of-the-box support for my one-to-many deployment scenario? Certainly! Am I surprised that Red-Gate hasn't built a toolset specifically for my admittedly uncommon use case? No, not surprised at all.
I hate being forced into the monthly subscription model. Cost and forced upgrades.
Latency Issues - Sometimes opening Source Control, SQL Search and SQL Prompt together, hangs the SSMS for a while. Unknown Change History - Sometimes SQL Source Control shows an SP / column was last modified by Unknown which causes issues when we try to sync the code with git. Tools not in sync - Sometimes when a add a new column to a table, SQL Prompt doesn't readily reflect that when I try to query that table, making me refresh the DB and then write the query.