SQL Comparison and Synchronization Toolkit™ (SQL Toolkit)
User testimonials
"We chose SQL Data Compare because we wanted a flexible replication solution that deploys easily, requires no changes to the source database, and needs little or no administration. Setting up replication between sites with the command-line utility is quick and easy. We can schedule data synchronization as often as we need it."
"I love the ability to use command-line functionality to specify the comparison of a single object or a set of objects. It's a quick way to determine if an object is the same between my development and QA environments."
"As we started a new development adventure moving our work order system from Cold Fusion to ASP.NET we were in need of a database re-write. As I started the process and got a new developer on board, it was quickly realized that keeping up with database schema changes was difficult. I checked out Red Gate's SQL Toolkit after I remembered hearing about it in one of my newsgroup's newsletters. It worked great. The best part about it, I figured out that I could add the Compare configuration files (for schema and data) to SourceSafe.
Now my other developer just gets the latest file version automatically, double-clicks on the file in Visual Studio and is able to quickly launch the Compare tools and get his local copy of the SQL database the same as mine. It has been an absolute time-saver for us. We can concentrate on development and not wasting time making sure the database schema is the same. Thanks for a Wonder Product!"
"Currently we keep a copy of each and every 'build' of our product stored on a backup SQL box that we use to do a compare against when we release each 'new' build. Our plan is to create a .NET app to generate snapshots of each build (and store them in Visual SourceSafe) so we can do this 'sanity check', not only prior to releasing a new build, but actually verify that client databases are properly synched at all times (by sending them a 'client' version of this app). We don't 'own' the client databases so they sometimes change without our knowledge. The Toolkit will help guarantee that our scripts will run successfully."




