The SDB Merge Tool has three different views with their key functions in the header and footer sections:
-
Object Hierarchy view
-
Data Comparison view
-
Details view
Object Hierarchy view
This view consists of all modules in hierarchical form. You can navigate to different tree nodes, select them, and perform a merge operation.
The merging process from the source to the target database must follow the same order
as the object hierarchy defined in the SDB Merge Tool. For more information, see Step 3: Migration of SDB database using SDB Merge Tool.
Data Comparison view
Source and target data grids
This view displays data from the source and target databases side by side:
-
Connected database details are displayed above the comparison grid view, and selected parent and data node details are shown in a hierarchy view.
-
When a node is selected in the object hierarchy view, data related to that node in both the source and target will be displayed in a data comparison view with the following background colors:
-
All identical records will have no color.
-
All Source Only or Target Only records will be highlighted in green.
-
All different records will be highlighted in orange.
-
-
If you select a record in the data comparison grid view, the attribute details from the source and target can be viewed in the details grid.
Tool bar - toggle selection controls
Data filters
To filter the data, you can select the following data filters present at the top of the grids:
Identical
When you select the Identical checkbox, records with the same values in the source and target databases are displayed.
Different
When you select the Different checkbox, records with different values in the source and target databases are displayed.
Source Only
When you select the Source Only checkbox, records present only in the source database are displayed.
Target Only
When you select the Target Only checkbox, records present only in the target database are displayed.
You can select multiple data filters at a time.
Tool bar - merge controls
Merge
You can select and merge one or more records from the source database to the target database (Different and Source only records can only be merged).
Unmerge
You can select one or more merged records and unmerge them by selecting Unmerge.
Undo
You can select Undo to undo multiple actions performed on the data, like CTRL+Z functionality.
-
The Merge, Unmerge, or Undo operation only shows the intended operation in the data grid and does not save the changes in the target database.
-
For all the records that are identical in the source and target, the Merge, Unmerge, or Undo action will be disabled.
Refresh
You can select Refresh to obtain the latest data at any time from both the source and target databases.
Excel Report
You can generate an Excel report of the data object selected in the data grid.
Delete and Replace
This functionality enables you to delete and replace the target database with the source database at different nodes, where you need to log on to the SRD application to delete the data in the target database. It deletes the data in the target database and replaces all the object data in the target database with the source database. This functionality is available only for a few data objects.
The Delete and Replace option is enabled only if there are Source Only or Difference records under that node.
Custom Compare
This functionality allows the comparison of different user-specified configurations, templates, data table mappings, or attribute mappings. Custom Compare is available only on the respective nodes under Smart 3D Integration.
Details view
In the Details view, attributes and respective values in the source and target databases are displayed for a selected row, side by side:
-
All identical records will have no background color.
-
All different records will have an orange background.
-
All Source only or Target only records will have a green background.
LMOD, User, and Int_Rev attributes are not used for comparison, but the differences
between these values will be shown in an orange background.
Footer bar
It displays the details of the selected object in the object hierarchy view:
-
Total - Count of records present in the source and target databases.
-
Showing - Count of displayed records if any data filter is applied.
-
Selected - Count of selected records.
-
Merged - Count of merged records.
The footer displays the language (NLS) in which you logged in.
This bar also contains the following two options:
-
SHOW DEPENDENCIES
-
SAVE TO DATABASE
SHOW DEPENDENCIES
It displays all the dependencies of the selected data. For example, a Commodity Code will have dependency on table details, commodity group, and part.
Functionality
-
When you select Show Dependencies, a tree structure hierarchy of dependent objects is displayed.
SAVE TO DATABASE
-
It saves the merged data records into the target database.
Header bar
When you select 
, at the right end of the header, the following options are displayed:
-
Help - Contains "SRD-SDB-Merge Tool.pdf", which describes the key features and how to use the SDB Merge Tool.
-
About - Explains the version details and incorporates software details.
-
Logout - Logs out of the SDB Merge Tool session.