Database Update Wizard
Database Update Wizard: Transferring Tables
How Does the Database Update Wizard Transfer Table Feature Work?
The Database Update Wizard is a middle-ware automation tool that implements the same abstract schema definition on different database servers. This allows the Archibus program and domains to use the same functionality regardless of which database server underlies the program. When migrating changes to your schema, the wizard can replace or merge the changes as desired.
The Database Update Wizard can automatically implement database features needed for real estate, infrastructure, and facility management. Because of this, the Database Update Wizard has several advantages over standard data modeling or reverse-engineering tools:
- It understands and transfers not only the SQL table definitions but also those aspects of the Archibus data dictionary that control editing and reporting. For example, the knowledge of drawing-driven fields such as Room Areas is preserved. The knowledge of bar code fields, such as Equipment Codes, is also preserved allowing bar codes to display in reports.
- It migrates other aspects of your site's schema, such as your lists of asset objects, your layering conventions, and your telecommunications connection hierarchy.
- It handles database server differences in memo field lengths, the significance of trailing blanks, and the differences in how date and time fields are used with different servers.
- It can make best use of the database server's native features to implement required functionality. For instance, auto-numbered tables are implemented using the AUTOINCREMENT default in Sybase, the IDENTITY constraint in Microsoft SQL Server, and triggers and sequences in Oracle.
Topics
Transferring Tables
Procedures for Transferring Tables