Database Migration Script

Run DB Migration

A migration script must be manually run to import properties.json configuration into the MongoDB database. After the migration script is run once, the properties.json file will only be referenced by IAP for the MongoDB connection properties, with IAP referencing the database for all other configuration properties.

Note: Any desired changes to properties.json should be made before proceeding.

1. Enter the directory containing the IAP migration script.

   cd /opt/pronghorn/current/node_modules/@itential/pronghorn-core/migration_scripts
   

2. Run the migration script.

   node migratePropertiesToDatabase.js
   

# Option 1) RabbitMQ installed on IAP server with default port.
node migratePropertiesToDatabase.js --userInputs protocol=amqp port=5672 hosts="localhost"

# Option 2) RabbitMQ installed on standalone server.
node migratePropertiesToDatabase.js --userInputs protocol=amqp port=5672 hosts="rabbitmq.test.com"

The properties.json file will be updated during the migration script run to only contain the MongoDB connection properties, with all other configuration parameters stored within the default MongoDB database named pronghorn. The migration script creates a backup of the original properties.json file that will look similar to properties_b4b03d30-ad00-4f61-bd9e-7953968ef8c4.json.

Migration Script Help Options

The migratePropertiesToDatabase.js script has a --help option that allows you to use the script in unattended mode with the --userInputs option. The following example depicts the various help options available and briefly explains how they are used.

Figure 1: Help Options

Option to Ignore Schema Errors

The migration script also has an option that will ignore schema validation errors during migration. Run the migratePropertiesToDatabase.js script, but this time add -i to the parameters.

node migratePropertiesToDatabase.js -i

Start IAP (First Time)

Once the migration script runs, start IAP. Refer to Start IAP (First Time) for more information.