2.7 Placeholder Management(placeholder.properties)

This topic provides the systematic instructions for placeholder management.

  1. Maintain all placeholders used by SQL as parameter.<key>=value; no trailing spaces.
  2. Do not change values of existing placeholders used in already-executed scripts (to avoid checksum errors).
  3. Create new placeholder keys for new updates instead of reusing old ones.
  4. To extract existing Flyway placeholders from PROPERTIES table:

    select REGEXP_REPLACE( key,'^flyway\..*\.placeholders\.','parameter.') ||'=' || value from Properties where key like '%.placeholders.%';

  5. Also refer setUserOverrides.sh for placeholders not defined in PROPERTIES.