General Procedure for Changing the Structure of the Database

When database structure changes are initiated by changing the Archibus data dictionary, the procedure for changing the physical structure of the database is as follows:

1. Using native database tools, make a backup of your database for safe keeping.
2. Use the Database Update Wizard to export a copy of the data dictionary tables. Save these files as a backup of the state of the data dictionary before you start making changes. (See How to Transfer Data Out .)
3. Make your changes to the data dictionary, as described below.
4. Use the Schema Change Wizard to apply your changes to the physical database. (See Starting the Schema Change Wizard .)
5. Restart the application server.
6. Restart the application.
7. Migrate the schema changes to other databases.

• Assuming that your facility has a development environment, it is presumed that the above procedure would be completed and tested in a development environment.
• Following successful testing, these changes would then be migrated to either additional test environments (such as beta test) or to production instances of the project.
• Before migrating the changes, you will want to compare the changed schema with the project databases so that you are aware of the exact changes that migrating will make. (See Comparing Data Dictionaries .)

Accessing the Data Dictionary

You can access the Data Dictionary tables in both Smart Client and Web Central.

In Smart Client:

• Sign in to the Smart Client with an account that has system administration access.
• Select System / Add In Manager .
• Choose Edit Archibus Data Dictionary to edit the table definitions.
• Choose Edit Archibus Field Dictionary to edit the field definitions.
  
  

Table and field editing functions are also available in Web Central under System / Add In Manager .

• Edit Archibus Data Dictionary displays the table definitions. Click on a table to see its fields.
• Edit Archibus Table Dictionary displays the table definitions.
• Edit Archibus Field Dictionary displays the field definitions.
• Add Field displays a form for entering essential properties of a field.
  
  

See Also

What Constitutes a Structural Change to the Database?

Understanding the Archibus Database

How to Add a Field to the Data Dictionary

How to Add a Table to the Data Dictionary

How to Delete a Field from the Data Dictionary

How to Delete a Table from the Data Dictionary

How to Add a Document Field to the Data Dictionary

How to Add a Validated Field to the Data Dictionary

Archibus Tables table

Archibus Fields table