SDB Merge Tool - Intergraph Smart Reference Data Standard Database - Version 2020 (12.0) - Reference - Hexagon PPM

Standard Database for Intergraph Smart Reference Data Management Summary (2020)

Language
English
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Reference
Standard Database for Smart Reference Data Version
2020 (12.0)

SDB Merge Tool is a utility that connects to two SDB databases and displays the differences in data between the two databases in the user interface.

The tool compares the data that exists in both the databases and displays it in a data grid side by side. Using this visual representation, users can choose which data they want to merge from the source database into the target database. Merging of data is always from the source to target database. Below is a screenshot of the Merge Tool.

The Merge Tool can also report the data from both the source and target databases in an Excel file. The user can click a node and report the data related to that object. The data is reported for each attribute value side by side. This allows users to easily compare the data differences.

In SDB 2018 R1 the SDB Merge Tool was enhanced to show the differences between the two databases in the tree hierarchy view. In the current release (SDB 2020), user has been provided an option to merge all the source only and data differences from source to target databases.

Users can log in to the Merge Tool using two modes:

  • Differences not shown in hierarchy - The tree hierarchy cannot filter the tree nodes based on data filter options.

  • Show differences in hierarchy - The tree hierarchy can filter the tree nodes based on data filter options.

    • Selective Merge of Data: In this mode, user can merge the required data only after complete database comparison is completed.

    • Complete Merge of Data: In this mode, all the data will be merged from source database to target database.

The following screenshot shows the mode options of the Merge Tool.

Differences not shown in hierarchy

When a user logs in using this mode, the tree hierarchy does not have the functionality to filter the tree nodes based on the data filter options. In this view, all the Identical nodes appear in a black font, whereas Different records are shown in orange. If the node exists only in the source or target database, it appears in blue with an (S) suffix or (T) suffix, respectively.

The following screenshot shows the user interface of the tool when it is used in this mode.

Show differences in hierarchy

When a user logs in using this mode, the tree hierarchy has the functionality to filter the tree nodes based on the data filter options. In this view all the Identical nodes have a black font color, whereas different nodes are shown in an orange font color. For Different nodes, the parent nodes to the root node level are highlighted in an orange font color, indicating to the user that the child nodes have differences.

Using this mode, the user can filter Identical, Different, Source Only, and Target Only nodes by checking and unchecking the data filters available above the hierarchy.

This is the preferred mode for complete migration of the SDB database to SDB 2020.

The following options are provided in Show differences in hierarchy mode:

  • Selective Merge of Data - If the user selects selective merge of data and clicks on Next, the user enters to the Merge Tool user interface with the differences shown in the hierarchy. This sub mode works the same as delivered in the SDB 2018R1 release.

  • Complete Merge of Data - In addition to the existing merge features, complete merge of data is a new feature added in the current release (SDB 2020). If the user selects this option and clicks on Next, the complete merge of data between source to target database starts.

    • Status “Not Started” indicates that the merging of data between source and target databases is not yet started. Status “Completed” indicates that the merging of data between source and target databases is completed.

    • An HTML log file is generated when complete merge of data is performed from source to target database, which reports all the data changes/additions into target database.

The following screenshot shows the user interface of the tool when it is used in this mode.