Update the Target Database

Compare/Update User Guide

Compare and Update Data : Update the Target Database

Click the top of the Update Database segmented button to immediately apply all the accepted changes to the target database, according to the selected configuration and default settings.

Click the bottom of the Update Database segmented button to review the settings and apply all the accepted changes to the target database.

The following sub-sections describe the process of updating the target database for a selection of supported database types.

Note:

The Update Database window adapts to the different results so as to show only relevant sections. For example if there are no linked items to update then that section will not appear.

Update the Schematic Database

This example shows an update of a schematic database with instrument data from AVEVA Instrumentation. The Update Database dialogue shows the statistics from the compare process and the choices that have been made for accepting changes.

Click UpdateDB to apply these updates. Once the update process has completed, the results summary will be displayed.

Note:

If an update error occurs for a particular attribute, only that attribute will fail to update. Other attributes on the same element will still be updated if possible.

The grid view will be updated to display any messages and errors, highlighting in the appropriate feedback colours.

Update the Catalogue Database

This example shows an update in Paragon of cable catalogue data from AVEVA Instrumentation.

Selecting Owner for an Element

In order to add a new cable catalogue entry, four elements need to be created in the Catalogue database and one element in the Property database. Owners must be selected under which new elements will be created.

The

button next to an element will when clicked display the Select Database Element window for owner selection.

The following table lists the element to be added along with its valid owner


Element Type	Valid Owner(s)
TABITEM	CTABLE
GPART	PRTWLD or PRTELE
SCOMPONENT	SECTION or CATEGORY
CCORSET	SECTION or CATEGORY
CABDATA	CMPTYPE

Update the Design Database

Note:

Before adding a cable element in the design database, make sure that the associated cable catalogue, start equipment and end equipment are present in the database. Without the associated elements a cable cannot be added to the design database and an error message will be displayed in the grid.

Note:

Even if there are no attribute updates to be made, there may still be data updates for source or target database references or internally mapped elements, resulting from the matching process. Refer to Instrumentation, Electrical and P&ID Elements Matching for further details.

Update one Dabacon Database from Another Dabacon Database

This example shows update of a design database with equipment data from an engineering database. The process is similar to those described above with the addition of options to handle linking.

Updating between Dabacon sources includes options for linking. Select from the following:

•

Link inserted items - when creating a new item in the target database, automatically link it to the source item.

•

Link matched items - automatically link a matched target item to the source item.

•

Update attributes for linked items - only use this if you want that data directly on the target item. Once the item is linked, you can reference that data from the linked source, e.g. from Design, use description of schlnk to get the linked schematic item's description in a report.

•

Unlink selected items - use this option if you have selected items in the grid that you want to unlink.

Note:

When unlinking selected items, it is the destination item that is unlinked. For example, when design, schematic and engineering items are linked together, performing the unlink operation in Design will unlink the design item from the other two (irrespective of the source database selection), leaving the schematic and engineering items linked to each other.

Click Update to apply these updates.