I’ve been looking at the documentation and trying anything I could find in the forum messages with no success so far. I’m looking to generate a single changeset from an existing local Sql Server database with multiple schemas.
Currently my command line is as follows:
liquibase --changeLogFile=myChangelog.xml --schemas=reference,config,logging,mapping,staging --include-schema=true generateChangeLog
Starting Liquibase at 15:51:30 (version 4.5.0 #52 built at 2021-09-27 16:19+0000)
Liquibase Version: 4.5.0
Liquibase Community 4.5.0 by Datical
BEST PRACTICE: The changelog generated by diffChangeLog/generateChangeLog should be inspected for correctness and completeness before being deployed.
Generated changelog written to /home/gdh/dev/Onyx/SAFHIR/src/data/databases/metadata/liquibase/myChangelog.xml
Output saved to /home/gdh/dev/Onyx/SAFHIR/src/data/databases/metadata/liquibase/output.sql
Liquibase command ‘generateChangelog’ was executed successfully.
However the generated content in myChangelog.xml does not contain any schema names:
<changeSet author="gdh (generated)" id="1635277893161-1"> <createTable tableName="ADFConfig"> <column autoIncrement="true" computed="false" name="ADFConfigID" type="int"> <constraints nullable="false" primaryKey="true" primaryKeyName="PK_ADFConfig"/> </column>
Can someone help please with the correct command line to generate including the schema names?