SDB Merge Tool - Intergraph Smart Reference Data Standard Database - 2018 R1 (11.1) - Reference - Hexagon PPM

Standard Database for Intergraph Smart Reference Data Management Summary (2018 R1)

Language
English
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Reference
Standard Database for Smart Reference Data Version
2018 R1 (11.1)

A new SDB Merge Tool was added in SDB 2018 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.

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

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

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

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 2018 database to SDB 2018 R1.

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