Liquibase Databasechangelog Table In Updatesql Mode

When I generate a SQL file out of my changelog file the databasechangelog table is created as a CSV file in the same folder as my generated SQL file but I want it as a table inside

Solution 1:

There is a way to include the databasechangelog table by using the outputLiquibaseSql parameter in the url

.\liquibase --url=offline:mssql?outputLiquibaseSql=true `
--changeLogFile="C:\Users\Ferid\Documents\Box Sync\PRIVATE_Ferid\liquibase-3.5.5-bin\Changelog.xml" `
--outputFile="C:\Users\Ferid\Documents\Box Sync\PRIVATE_Ferid\liquibase-3.5.5-bin\all.sql" `
updatesql

This causes sometimes trouble with CMD or PowerShell (because of the questionmark) so it can be helpful to include it in the liquibase.properties file.

Solution 2:

You need to change the URL you are using to a non-offline version.