Migration on vertica database

It is highly recommended to make a backup existing database before migration. Do not use the database during migration. To prevent database corruption, do not stop migration.

If using vertica database it is possible to migrate from 1.0.6 version to 1.1.2 using sql script.

To run the script:

vsql -f "./base_scripts/vertica_scripts/migration_1_4_to_5.sql" -U DB_USER -w DB_PASSWORD -d DB_NAME -h HOST -p PORT

where DB_USER is the database user, DB_PASSWORD is the user’s password, DB_NAME is database name, HOST - database host, PORT - database port.

If the database is large it can take much time. Some fields that could be empty in previous version (for event table: account_id, attribute_id, event_id, handler_id; for attach_result table: list_id; for detect_result table sample_id) cannot be nullable in new version. If one of above fields was empty, it will set 00000000-0000-4000-b000-000000000555 to make database compatible with new version.