"I've been really missing a neat data comparison tool - SQL Data Compare Pro seems to be the answer to my prayers. I receive backups from customers and need to compare data with predefined datasets. My normal way of comparing involves these steps:

1) I restore the customer backup
2) I compare specific tables and views by using UNION ALL operation (it's a very tedious and time consuming process!)

The first thing I tried with SQL Data Compare Pro 6 was to grab my latest customer backup and compare directly against it. The result was impressive, and the GUI is really easy to use. This operation normally takes me hours (restore backup, then there's lack of diskspace and so on), but with SQL Data Compare, it took me no more than minutes." Jan Hansen, Database Architect, Marel Food Systems

''The compare Live DB to SQL Server Backup is GREAT! I used to routinely restore my backup files to a temporary DB to do this, and this will save tons of time.'' Justin Webster, Software Developer/Technical Lead

"I love the ability to compare against a backup file. I am unable to do data comparisons on production, due to the impact that would have, and the constantly shifting data, so having to copy a backup file to a different server and then restore it is a pain. Being able to compare to backup files is even better! Talk about time savings!"Benjamin Lam, Alpha tester of SQL Data Compare 6

"Love your products, service, and support. I am only a two-man shop, but feel like I get a good deal for my hard-earned money when I deal with you guys. If I were across the pond, I'd buy you a pint of Guinness. Cheers from Baton Rouge, Louisiana (USA)" Calvin Fabre, High Power Consulting, Inc.

"One of the key draws for Red Gate tools has always been the price point and the rapid return on investment. The SQL Bundle has been a standard for my toolbox since 2000, across 4 jobs." Peter Daniels, Database Administrator, InComm

"SQL Compare and SQL Data Compare are the best purchases we've made in the .NET/SQL environment. They've saved us hours of development time and the fast, easy-to-use database comparison gives us maximum confidence that our migration scripts are correct. We rely on these products for every deployment." Paul Tebbutt, Technical Lead, Universal Music Group

"All the Red Gate products I used are a delight – SQL Bundle and ANTS Profiler. Simple to use, powerful, fast – awesome. I told some of our DBAs that they MUST use your products. If you are a DBA and reading this testimonial, and if you don't use Red Gate's software, trust me! You should. I have never written a testimonial before, but I felt compelled to do so in this case. I cannot stress strongly enough how wonderful this company's tools are. THANK YOU!" Doron Grinstein, Technical Director, Information Technology, Walt Disney Studios

"...SQL Data Compare has given us a first look test approach to ensure we don't get any surprises when upgrading databases. Our warehouses contain around 8 TB of SQL data so they're not trivial. Like I said, great product, great value." Mark Hickin, Touch Clarity Limited

"It's user friendly. Everything you need for comparison is right there on one screen. There is no need to move back and forth between menus and different screens." Jim Orzel, Supervisor of Data Operations, Divestco

"It's very intuitive. The interface is clean and it's obvious what everything is there for. I was pleasantly surprised by the speed. I usually hand-code SQL queries when moving databases between environments and doing synchronization and replication checking. With SQL Data Compare, I can save up to several hours for each database. SQL Data Compare v3 is simple, quick and it saves time. Simply put, it does what it sets out to do." Jasper Smith, SQL Server MVP

"Just wanted to thank you for a great product. I have a bundle with SQL Compare 5 and its partner Data Compare. I have used SQL Compare a couple of times lately when moving our new development stuff to live server to save time. Works beautifully.

Then yesterday we had to move our production server to another and bigger server. By using SQL Compare and Data Compare, we managed to move our 5 GB database to our new server with approximately 30 seconds of downtime... We just used SQL Compare to sync up the schemas, and then used SQL Data Compare when the old system was live. Then we took the system offline, ran another sync with only the changed data, and put the new system online. Extremely easy." Morten Petterøe, CEO, Towah Entertainment Ltd

"I have developed a small time-tracking system for my company. The development version sits on my laptop and the production version runs SQL Server 2005 on our network. Since the database is still quite tiny, I like to keep both versions in close synchronization.

After returning from PASS there was a difference of nearly 50,000 records. Which was faster? Backing up and restoring, or running Red Gate Data Compare? Of course there was no contest; Data Compare had the systems synchronized before I would have finished typing out the T-SQL backup command." Michael Garstin, SQL Server Support Technical Lead, VMC Canada