Compare Tables
This tool compares values in two specified tables. It can remove the
matches from one or both tables, or create a new tables with matching
values.
Connection
Sets the database connection properties. This option allows you to choose
the name of the connection from the drop-down list.
Create new table with the results
The program will create a new table using
results of the comparison.
Table name
Sets the names for Table1 and Table2.
Column name
Sets the name of a column for each table. The program will compare values
from specified columns.
Remove results
Deletes all records that do not match the selected criteria
Create backup copy of the table
Sets the value indicating whether to create a backup copy of the table
before performing any action.
Backup table name
Sets the name of the backup table.
Action
|
Action |
Description |
|
0 - Find the values that exist in both tables |
Select this option if you want the program to search
for data which can be found in both tables. |
|
1 - Find the values that do not exist in both tables |
The program will search only for data which do not
exist in the other table. |
|
2 - Find the values that exist only in Table1 and
not in Table2 |
The program will search only for data in Table1, that
cannot be found in Table2. |
|
3 - Find the values that exist only in Table2 and
not in Table1 |
The program will search only for data in Table2, that
cannot be found in Table1. |
Find only the values that exist in both tables
Select this option if you want the program to search for data which
can be found in both tables.
For example, if you are comparing tables with records as follows:
|
Table1 |
Table2 |
|
1 |
1 |
|
2 |
3 |
|
4 |
5 |
|
6 |
6 |
The result will be: 1, 6
Find the values that do not exist in both
tables
The program will search only for data which do not exist in the other
table.
For example, if you are comparing tables with records as follows:
|
Table1 |
Table2 |
|
1 |
1 |
|
2 |
3 |
|
4 |
5 |
|
6 |
6 |
The result will be: 2, 4, 3, 5
Find the values that exist only in Table1
and not in Table2
The program will search only for data in Table1, that cannot be found
in Table2.
Example:
|
Table1 |
Table2 |
|
1 |
1 |
|
2 |
3 |
|
4 |
5 |
|
6 |
6 |
The result will be: 2, 4
Find the values that exist only in Table2
and not in Table1
The program will search only for data in Table2, that cannot be found
in Table1.
For example, if you are comparing tables with records as follows:
|
Table1 |
Table2 |
|
1 |
1 |
|
2 |
3 |
|
4 |
5 |
|
6 |
6 |
The result will be: 3, 5
Related Topics:
Advanced settings
Schedule package
for later execution
Scheduling options
Repair E-mail Addresses
Search and Replace
Filter Records
Filter Through Text File
Remove Duplicate Recipients
Remove Duplicate Records
Execute SQL Query
| 
