Previous Next JavaScript must be enabled to correctly display this content

## 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.

Parent topic: SQLCL Deployment