I want to generate a changelog from an existing schema. When examining the resulting yml file, the foreign key changeset does not include:
referencedTableSchemaName
baseTableSchemaName
How can I have these two parameters included?
My current sytnax:
liquibase
–changeLogFile=dbchangelog.yml
–url=jdbc:oracle:thin:@${L_PDB_CONNECT_STRING}
–username=myuser
–password=mypassword
–include-schema=true
generate-changelog
–schemas=schema_a
–includeObjects=table:TABLE1,TABLE2
–overwrite-output-file=true
Resulting foreign key change set:
- changeSet:
id: 1628000119109-4
author: crueppri (generated)
changes:- addForeignKeyConstraint:
baseColumnNames: ID
baseTableName: TABLE1
constraintName: TABLE1_FK
deferrable: false
initiallyDeferred: false
onDelete: RESTRICT
onUpdate: RESTRICT
referencedColumnNames: TABLE1_ID
referencedTableName: TABLE2
validate: true
- addForeignKeyConstraint: