Custom database objects

Custom database objects such as Views, Transpose Functions and Transpose Function Tables are stored in the PI AF Configuration database. When exporting a database through PI AF System Explorer, these objects are not included. If a database needs to be re-imported or moved to another system, the custom database objects need to be copied separately.

PI SQL Commander Lite offers an export/import wizard for custom database objects. For details, see the sections Import custom database objects and Export custom database objects in the PI SQL Commander Lite Help.

Note: Direct export or import of the Configuration database elements that represent PI SQL custom database objects does not work.

Custom Database Objects may become invalid if AF element templates are modified. Examples are renamed element templates or removing an attribute template from an element template. Currently such objects need to be dropped and recreated using the new AF structure. Because the original CREATE statement is not accessible from external tools, OSIsoft recommends using the Export Custom Database Objects functionality right after the creation of new objects to document what has been customized and potentially use this to recreate the custom objects if necessary.