Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Oct 23, 2007

Red Gate Software's SQL Compare 6.10

By Steven Warren

Red Gate Software, a leader in SQL Server tools for .NET professionals recently released SQL Compare 6.10. In short, the tool allows you to compare and synchronize all database objects, including tables, stored procedures, views, user-defined functions, XML schema collections, and CLR assemblies.

This tool is very simple to use and it basically looks for information about your company’s structure or schema and then scripts out the entire database. It goes on to compare both databases and identifies the differences allowing you to synchronize the database in any given direction. All dependencies and referential integrity are maintained during this process.

John Allman, senior DBA with United Health Group, states, "I just wanted to say a few words about SQL Compare. It is probably the best value in software that I've ever gotten in my life. For what you pay for that and the utility you get out of it, I just can't understand why everybody doesn't have it.”

As a DBA consultant in the trenches, I can’t tell you how valuable it is to have a set of tools that allows me to compare my production database to a live backup. In the past, I had to restore the data to a temporary database and this could take many hours depending on the size of the database.

With this tool, you have the ability to compare a live SQL Server database with its backup without having to restore the backup, which is time consuming, or copy from your SAN\NAS to the local disk. Can you imagine how much time your are saving?

With SQL Compare you have the ability to compare and synchronize databases, compare backups, SQL Server 2005 support, compare primary keys and unique indexes, custom comparisons, indexed views support, pivot-view navigation, and compare large databases that could contain gigabytes of data. SQL Compare is so powerful; you can synchronize a row, table, and/or an entire database. It is so easy to use, practically simplistic, but very powerful.

Furthermore, "If you develop on a live database, you can now use SQL Compare 6 to update a set of SQL script files that represent the database schema," says Andras Belokosztolszki, the architect of the last three versions of SQL Compare. He goes on to say, "This opens the door to placing source control at the heart of the development process, providing a way to control and track database design changes in a detailed and meticulous manner."

Many database administrators have a variety of tools in their repertoire. This is just one tool that needs to be handy in case the need arises to rebuild databases or just compare databases quickly and efficiently. In a world where most IT people must hybrid themselves by being a database administrator and an Engineer, having tools that save time becomes a must. We live in a world, “Can you get this done by end of business (eob), today.”

Jasper Smith, SQL Server MVP states, “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 on each database.” He goes on to say, “SQL Data Compare is simple, quick and it saves time. Simply put, it does what it sets out to do.”

In order to use this tool, you must have SQL Server 2000 or SQL Server 2005 installed. SQL Compare also requires the following Operating Systems in order to function properly:

  • Windows 2000
  • Windows Vista
  • Windows 2003 Server
  • Windows XP
  • Microsoft.NET Framework 2.0
  • MDAC 2.8
  • 128 MB RAM
  • 25 MB of disk space required for installation

As far as cost in concerned, a standard license of SQL Data Compare will run you about $395.00. The Professional Edition runs $595.00, which includes access to the command line interface as well as the Compare to Backups feature.

According to Peter Daniels, DBA of InComm, “One of the key draws for Red Gate tools has always been the price point and the rapid return on investment (ROI). The SQL Bundle has been a standard for my toolbox since 2000, across 4 jobs.”

You can take advantage of their 14 day-day free trial by simply downloading the product. After you download SQL Compare for 14 days, you have a fully functioning product for 14 days.

About Red Gate Software

“Red Gate Software makes ingeniously simple tools for Microsoft technology developers and database administrators. Since 1999, Red Gate Software has been developing ingeniously simple tools that simplify the business of working with SQL Server and .NET. Our tools, which include SQL Compare, SQL Backup and ANTS Profiler, have become industry standards for developers and DBA's worldwide.

We count Microsoft, HP, Sage, Bank of America, AT&T, The US Treasury, and over 95,000 other leading organizations as customers, and there are over 200,000 Microsoft technology professionals currently using Red Gate products.”

For more information of RedGate products, visit http://www.red-gate.com/index.htm.

» See All Articles by Columnist Steven S. Warren



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM