sohogenerous

By: Greg Robidoux Last Updated: 2018-05-05 Comments (9) Related Tips: More >DBA Best Practices

Problem

There is often the need to compare both data and database structures from two databases either on the same server or on different servers. Most text editors have a built-in process to allow you to do a diff and identify any differences between the two files, but comparing data is not quite that easy. Using this diff process is great if you only want to compare a few files, but what if you need to scan your entire database to look for differences?

As with anything you can always create your own application to automate the comparison process. You could cursor through all of the tables read the T-SQL from one server, get the T-SQL for the same object from the other server and do a comparison. To compare the data you can write scripts that read row by row and do a comparison of the data. But why bother when there are so many products out there already.

Solution

Luckily a lot of products already exist. These products allow you to compare database objects, data, DTS scripts, servers, etc.. In addition, these products are not all that expensive either. Some of the products are under $100 US and I also found a company that offers a free version, see below.

Following is a list of the various products that allow you to do comparisons:

Object Comparison

• AdeptSQL Diff (no longer available)
• Best SoftTool - SQL DBCompare (no longer available)
• PrimeLogics - DataVision 2007 (no longer available)
• Quest - SchemaCompare (no longer available)
• SQL Effects (no longer available)
• Voltex Data Systems - SQLDBcontrol (no longer available)
• XpressApps - sqlXpress Diff (no longer available)

Data Comparison

• Best SoftTool - SQL DBCompare (no longer available)
• Quest - DataCompare (no longer available)

DTS Comparison

• Red Gate - DTS Package Compare (no longer available)

Server Comparison

• Quest - ServerCompare (no longer available)

Free Tools

• SQL Effects CE Edition (no longer available)

If there are other products out there send an email to [email protected] and we will update this list.

Also, check out these tool pages:

Next Steps

• Next time you need to compare your database objects don't waste your time doing it manually. Purchase one of these products or download the free version and give it a try. Most if not all of these vendors offer free trial versions.
• Determine what needs to be compared and how frequently. Look at the different options that allow you to compare objects, data, dts packages and even servers.
• We provided the list of products, so take this list and find the product that is right for you.

Last Updated: 2018-05-05

About the author

• Download

If your download is not starting, click here.

Thank you for downloading SQL Data Compare from our software library

The download version of SQL Data Compare is 12.3.3.4490. You are about to download a shareware program. It may sharply differ from the full version of the program due to the license type.

Each download we provide is subject to periodical scanning, but we strongly recommend you to check the package for viruses on your side before running the installation. The download is provided as is, with no modifications or changes made on our side.

SQL Data Compare antivirus report

This download is virus-free.This file was last analysed by Free Download Manager Lib 146 days ago.

CLAMAV

NOD32

WebAdvisor

Mar 1, 2018 - Download Instructions for download: • Click 'Download' button • If the image doesnt shows you can click direct link: • After you click you'll go to. Download cracked Home Design 3D GOLD IPA file from the largest cracked App Store, you can. Date: 2019-01-10 10:35 Version:4.3.2 For iOS 11 For iOS 10. Home design 3d gold-v2.01.ipa. May 2, 2017 - With Home Design 3D, designing and remodeling your house in 3D has never been so quick and intuitive! Accessible to everyone, Home Design 3D is the reference interior design. FURNISH AND DECORATE - Design and decorate both the interior and outdoor of your home. IPhone Screenshot.

Often downloaded with

• Comp-U-Floor for WindowsComp-U-Floor is all inclusive ERP software designed specifically for the floor..$49DOWNLOAD
• Pelikan CompaPelican Compa is a program designed for displaying information to office..DOWNLOAD
• Data Compare for OracleData Compare for Oracle can compare Oracle tables and deploy differences. You..$495DOWNLOAD
• Data Comparer for PostgreSQLEMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for..$47DOWNLOAD
• SQL Data GeneratorCreate large volumes of data within a couple of clicks in SQL Server Management..$369DOWNLOAD

EMS Data Comparer 2007 for PostgreSQL

Database Tools

Devart dbForge Data Compare for MySQL

Database Tools