When you open the Export dialog, the tree hierarchy on the Definitions pane is populated with information from the Optim™ Directory.
You can select the check box for an object type in order to export all definitions of that type or expand the list and select definitions to be exported by qualifier or name. Tools menu commands allow you to select or de-select all definitions.
The name of the Output File. The Output File is a text file and is given a .txt extension automatically. Other extensions may be specified, or the file can be designated without an extension. The Output File is used as the Input File for Import Processing.
Option to append definitions to an existing Output File or replace the contents of the file.
Option to import subordinate objects. Select the check box to export subordinate objects with the objects. Note that Local definitions are always exported (e.g., a Local Access Definition is exported as part of an Extract Request). Objects and possible subordinate objects are:
Primary Object | Subordinate Object(s) |
---|---|
Access Definition | Relationships |
Archive File Collection | none |
Archive Request | Access Definition Storage
Profile Report Request |
Calendar | none |
Column Map | Column Map Procedures |
Column Map Procedure | none |
Compare Request | Access Definition Table Map Column Maps Column Map Procedures Report Request |
Convert Request | Table Maps Column Maps Column Map Procedures Report Request |
Currency Table | none |
DB Alias | none |
Delete Request | none |
Edit Definition | Access Definition Report Request |
Extract Request | Access Definition |
Insert Request | Table Map Report Request Column Maps Column Map Procedures Report Request |
Load Request | Table Maps Column Maps Column Map Procedures Report Request |
Primary Key | none |
Relationship | none |
Report Request | none |
Restore Request | Insert Requests Load Requests Table Maps Column Maps Column Map Procedures Report Requests |
Storage Profile | none |
Table Map | Column Maps Column Map Procedures |
In addition to standard File and Edit options, you can use the following commands from the File and Tools menus on the Export dialog:
The Export Utility allows you to develop a strategy to meet the needs of your installation. For example, you may want to copy one Extract Request with all subordinate objects and another Extract Request with none of the subordinate objects. As another example, you may want to export an Access Definition from one Optim Directory, supplement it with relationships from a second Optim Directory, and include Table Maps from a third.
For either example, you would run Export several times. If certain objects are intended for one Optim Directory and others for another, you might direct the exported objects to different Output Files, and import each file as needed. Alternatively, you can use Export to direct the exported objects to a single Output File by selecting the Append definitions to output file check box for each Export. Then, you can import all of the objects in one step, using the single Output File as input.
To start an export in the Export Utility, choose Run from the File menu. During Export Processing, the Export Progress pane displays the number of objects of each type that are exported and the number of errors encountered.
If errors occur during Export Processing (for example, a dropped object is selected for export), an error message is displayed. Objects for which processing errors occur are also represented visually by a red “X” and errors are written to the Export Process Log. You can check the Export Process Log for diagnostic information about errors.