Schema Change Wizard

The Schema Change Wizard reviews the current project's Archibus data dictionary (the Archibus Tables and Archibus Fields table) and creates new tables and fields and alters existing tables and fields so that the SQL database tables (the structure of the tables as currently defined in the database) match the definitions of the data dictionary.

Use the Schema Change Wizard to:

compare a project database against the data dictionary of a new standard Archibus schema.
compare a project's data dictionary against the actual SQL structure of the project database.
compare the SQL structure of two project databases.

For the above comparisons, you can obtain a detailed list of differences and then decide, on a field-by-field basis, which changes to implement.

You can choose how the Schema Change Wizard makes its changes:

immediately update the project database with the changes you accept.
write the specified changes to an SQL script file, which you can then apply to the database.