Update the Target Database

Click the top of the Update Database segmented button to immediately apply all the accepted changes to the target DB, 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 DB.

The following sub-sections describe the process of updating the target DB for a selection of supported DB 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 DB with instrument data from AVEVA Instrumentation. The Update Schematic 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 colors.

Update the Catalog Database

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

Selecting the Owner for an Element

In order to add a new cable catalog entry, four elements need to be created in the Catalog DB and one element in the Property DB. 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:

Update the Design Database

A similar process can be used to update a design DB with cable, equipment and instrument data from AVEVA Instrumentation, or cable and equipment data from AVEVA Electrical.

Note:
Before adding a cable element in the design DB, make sure that the associated cable catalog, start equipment and end equipment are present in the DB. Without the associated elements a cable cannot be added to the design DB 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 DB references or internally mapped elements, resulting from the matching process. For further information, refer to Instrumentation, Electrical and P&ID Elements Matching.

Update one DABACON Database from Another DABACON Database

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

Updating between DAtaBAse CONtrol Program (DABACON) sources includes options for linking. Select from the following:

• Link inserted items - when creating a new item in the target DB, 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, fro example 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 DB selection), leaving the schematic and engineering items linked to each other.

Click Update to apply these updates.