Schema changes when upgrading the application - Data360_DQ+ - 11.X

Data360 DQ+ AWS Installation

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
11.X
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ AWS Installation
Copyright
2024
First publish date
2016
ft:lastEdition
2024-06-06
ft:lastPublication
2024-06-06T12:37:34.761477

When upgrading the application, you will need to run a number of SQL statements on ApplicationDb (PostgreSQL). The statements that you need to run depend on your currently installed version.

Upgrading from 7.1

If you are upgrading to the latest release from 7.1, please run the following SQL statement:

  • CREATE EXTENSION IF NOT EXISTS pg_trgm;

Upgrading from 5.2 or 6.2

If you are upgrading to the latest release from 5.2 or 6.2, in addition to the above statement, please also run the following SQL statement:

  • ALTER TABLE caf_verdefcontentdep ALTER COLUMN fromfieldpath TYPE text, ALTER COLUMN tofieldpath TYPE text;
Note: After applying schema changes, restart the application server.