Comparing Full Table

The Full Table Component tool lets you quickly detect differences between certain tables in different Tidal databases. The full table comparison is based on matching primary keys in the tables and so the tool can be used to view differences between an original Tidal DB and a version that has been migrated to a new version of Tidal.

Similarly, it can be used to compare a DB with a historic backup of that same DB. The Compare Full Table tool is accessed by selecting Compare Full Table Compare.

The Compare Full Table control has two tabs:

  • Compare Tables

  • Compare Results.

The default tab displayed is Compare Tables.

The Compare Full Tables Tab

The Compare Tables tab displays two DB selectors, side-by -side, designated DB A and DB B.

Note: The selected DBs must belong to the same Tidal instance. Alternatively, they may belong to the same Tidal environment if the ‘AllowCompareWithinTidalEnvironment’ license feature is enabled. Comparison of DBs across Tidal environments is not supported.

Once DB A and DB B have been selected, you can click Compare to run the compare operation and open the Full Table Comparison summary view.

Selecting Load Saved Results, you can load Full Table Compare results set that were previously saved to a file.

The Compare Full Table Results Tab

The Compare Results tab view presents a summary of the comparison results for comparing various tables.

Data Summary Areas

Data Summary areas include:

  • jobmst Comparison

    The jobmst area summarizes the comparison result of the jobmst tables in the DBs.

    Each row compared represents a separate job definition in the jobmst table.

  • jobdtl Comparison

    The jobdtl area summarizes the comparison results of the jobdtl tables in the DBs.

  • jobdep Comparison

    The jobdep area summarizes the comparison results of the jobdep tables in the DBs.

  • evntmst Comparison

    The evntmst area summarizes the comparison results of the evntmst tables in the DBs.

  • usrmst Comparison

    The usrmst area summarizes the comparison results of the usrmst tables in the DBs.

All tables are compared based on the primary key column in each table; jobmst_id, etc.

Each data comparison summary section contains a summary of the comparison result relating to the data for A and B respectively.

For A and B:

  • Total number of rows compared.

  • Number of rows with differences.

  • Number of unique rows.

  • Total number of columns compared.

  • Number of unique columns found.

Save and Load Compare Results

The results of the table comparison can be saved to a [.EXTC] file by selecting Save. These can be reloaded from the file at a later time by selecting Load or Load Saved Results on the Compare Tables tab.

Viewing Details of the Comparison Results

Select Detail in any of the summary areas to open a Detail Comparison View for the respective data area.