SQLDBCompare

Comparing Data Records

The SQLDBCompare will allow you to compare schema of all SQL objects as well as the data records in the tables and views. Comparing data in tables/views is a time and resource (computer processing speed, memory usage, etc) intensive usage process. The SQLDBCompare has following capabilities.

Two comparing tables might have the same or different structures.
User can select sorting orders of comparing data records by choosing data columns.
User can select link column(s) of the comparing tables if the two tables have the same structure.
User defined comparing data using SQL statements and compare data in window and command line application.
Limiting number of comparing data records by setting constraints. Limit number of records to compare is crucial when compare data that have a lot of records.

Comparing Two Tables that have Same Structures

This section discusses how to select database columns in the data record comparing process.

Comparing Two Tables that have Different Structures

This section helps you to compare data records in two tables that have different structures. Users can select columns that having same name and data type to compare.

Comparing data in user defined SQL statements

This section will help you to define comparing data using SQL statement. By using this feature, user can compare any data that defined by SQL statements. It will help you to save the data compare configuration to a file for compare data at command line.

Comparing Data on Command Line

This section will help you to compare data at command line.

Limiting Records to Compare

This section will help you to limit number of comparing data records in two tables. By limiting number of comparing data records two tables, users can compare tables that have a lot of data records.

Viewing Content of a Record

This section describes how to browse the content of a data record.

Viewing Differences of two Records

This section describes how to view the differences of two data records.