BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

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

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.