SQL Compare box shot

SQL Compare®

Case studies

Improve internal SQL update processes

Scope iT, a web-based cost estimation and project planning company, needed to remove a bottleneck when updating their production databases. Using SQL Compare has meant the time spent comparing databases and scripts has reduced from two weeks to four hours, allowing DBAs to concentrate on scripts that modify and migrate customer data.

SQL Compare helps African relief efforts

Alex chose to use SQL Compare to help manage and enable worldwide use of information collected for an environmental impact appraisal and monitoring program. It's saved him and his client time and money and, in its turn, many Africans and their cattle!

Keep in synch with clients using SQL Compare

Software company, The System Shop Inc., needed a way to keep client database structures consistent with the company's master database. By using SQL Compare, monthly updates are now carried out on time because it no longer takes hours to synchronize databases.

Gain speed, ensure accuracy in object promotion process

AMS uses Red Gate's tools to manage four servers in two cluster groups, several databases on dedicated application servers for production, and four servers in a test/pre-production group.

Updates and changes made in minutes, not hours

Making beer is considered by many Australians to be a public service. Read about how Red Gate SQL Tools are used to assist in making this internationally important beverage.

Increase the speed of daily database updates

Huge amounts of information and frequent database changes are a way of life at Total Information Services Inc. (TISI), a leading pre-employment screening company.

Save time; help your home life!

Mark Payton spent a lot of time tweaking databases and frequently missed dinner with his family. SQL Compare has saved him enormous amounts of time, and he hasn't missed a dinner with his family since.

Discovering security uses for SQL Compare

In this case study, András Belokosztolszki aims to unravel the complex MS SQL Server security components, by showing how SQL Compare can assist with administrative tasks.

Using SQL Compare in web development

The Red Gate website – an ASP.NET site running on SQL Server 2000 – recently underwent a major overhaul. Here, Richard Mitchell and Steven Davidson, the developers on the project, describe how they used Red Gate's database schema-comparison tool, SQL Compare, as an integral part of their project environment.