Database Update Wizard

An Archibus tool that migrates Archibus project data and documents from a source project to a destination project that has a superset of the source project’s schema.

The Database Update Wizard transfers out all tables and data to a series of .csv extract files and document files (docx, xlsx, .txt, etc.) associated with the database records and then reads these extract files into a destination database. The Wizard can run a script that specifies these changes.

You can use the Database Update Wizard to perform such tasks as:

  • transferring data between Oracle and Microsoft SQL Server
  • creating a data dump of an Archibus project database
  • upgrading a project database to a new version of Archibus

The DUW offers two methods for updating a non-customized schema between releases:

  • DUW Update Scripts -- This process consists of running each release’s DUW scripts. This is the standard method beginning with V.23.2.
  • Transferring Tables -- This transfers all tables in your project to another project that has a superset of the first project’s schema. The Database Update Wizard lists the changes it will make, so that you can accept or reject the changes on a field-by-field basis.

See also: