Migrating from a Firebird-based to Oracle-based Vault Installation

Parent page: Altium Vault - Details for IT Departments

Many organizations already utilize an Oracle database as the back-end for their existing systems. Hosting the Altium Vault on their existing infrastructure is an attractive proposition, since it reduces installation and management complexity. And while the Oracle database type can be chosen directly as part of initial Vault installation, many designers choose to first experience the Altium Vault in its default guise, a guise that uses a Firebird database as the back-end for data storage. This could be to 'test the waters' as it were, before integration with their existing Oracle database, or it could be that an Oracle-based system is introduced into their organization at a later stage.

Whatever the reason, there needs to be a streamlined tool for taking the current Altium Vault-on-Firebird installation, and essentially switching to an Altium Vault-on-Oracle installation, with data migrated safely and securely between the two. This migration functionality is available as a mode in the Vault Migration Tool.

Pre-Migration Preparation

Before migration can proceed, there are some prerequisite steps that need to be performed - 'pre-migratory' checks, as it were.

• To access the Vault Migration Tool, you need to first download and run a small executable – avmigration.exe. This executable can be obtained by downloading a zip file - Altium_Vault_MigrationTool_<VersionNumber>.zip - available from the Legacy Downloads for Vault Technologies page, and can be saved anywhere on your hard disk. Extract the downloaded zip file, which contains this executable, along with the files avmigration.exe.manifest (which ensures the utility is run as administrator) and VaultMigrationTool.sql (providing the smarts of the migration features).
• The Altium Vault requires not only the OCI client, but also relevant .Net connectors. It is recommended to install .NET Framework v4.0, and the relevant 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio, in accordance with the version of Oracle you are running.
• Your current Vault must be an Altium Vault. If using a legacy Altium Vault Server (v1.1, v1.2), upgrade to a later version of Vault first.

Migrating the Data

Right-click on the avmigration.exe file and elect to Run as administrator. The Vault Migration Tool dialog will appear. The tool can be configured in different modes, to suit a variety of different purposes. S imply choose the last entry in the Migration Mode region - Altium Vault (Firebird) -> Altium Vault (Oracle).

Use the Vault Migration Tool to move from using an Altium Vault based on Firebird database installation, to an installation that is based on an Oracle database backend.

Use the various fields in the dialog to specify information required by the migration process. This information primarily relates to installation paths for the source (existing) Firebird-based Altium Vault, and options relating to installation of the new target (Oracle-based) Altium Vault, as well as parameters for access to the organization's Oracle database.

• Source - Altium Vault (Firebird) - this region provides controls for specifying the following information, relating to the source (existing) Firebird-based Altium Vault:
  • Vault path - enter here the path to the source Altium Vault executable folder. For a default Altium Vault installation, this will be \Program Files (x86)\Altium\Altium Vault\Vault\. For a non-default install, this will be in the location to which you installed the original vault. Double-clicking on the field will give access to the Select Directory dialog, which can be used to browse to, and select, the required directory.
  • Database file - enter here the path to the Altium Vault database file. For a default Altium Vault installation, this will be \ProgramData\Altium\VaultServerData\DXPServer.dat. For a non-default install, this will be in the location to which you stored that folder.
  • File repository path - enter here the path to the Altium Vault file repository. For a default Altium Vault installation, this will be \ProgramData\Altium\VaultServerData\Revisions\. For a non-default install, this will be in the location to which you stored that folder.
  • Backup File Name - enter here the path to a backup zip archive (*.zip). Essentially, you are specifying where, and under what name, a backup file is to be created by the Backup Tool. A backup of the original Firebird-based Vault is made as a matter of course, more for peace of mind, just in case any technical glitches do occur in the migration process.

• Target - Altium Vault Oracle based parameters - this region provides controls for specifying the following information, relating to access of the organization's Oracle database:
  • TNS Name Alias - enter the TNS Name Alias defined for the Oracle database to which you wish to connect. The TNS (Transparent Network Substrate) Alias is a pointer to the database. It includes the server address, port and SID (Service Identifier). The alias is declared and defined in the relevant tnsnames.ora file.
  • User - enter here the username portion of your Oracle database login credentials.
  • Password - enter here the password portion of your Oracle database login credentials.
• Altium Vault Installer - enter here the path to the Altium Vault Installer executable. This is used to install the Altium Vault again, but this time using Oracle as the database back-end.

With all required information specified, click the Run button to proceed with the migration. As migration proceeds, messages will be displayed on the tool's progress in the lower region of the dialog. The process completes with the final message "Migration successfully finished". The actual migration process can be broken down as follows:

1. The Backup Tool is launched, and makes a backup zip of the current Altium Vault install, in accordance with the entry specified in the Backup File Name field.
2. The current Altium Vault is uninstalled - leaving the data intact.
3. The Altium Vault is then re-installed, using the executable specified in the Altium Vault Installer field.
4. The database connection parameters are passed to the Installer from the Vault Migration Tool (TNS Name Alias, User, and Password), and all data is then copied from the original Firebird database to the Oracle database (both databases have the same structure).