How to generate changlogFile in.sql format?

liquibase

Solution

Add param:

--changeLogFile=fileName.databaseType.sql

This is my worked sample (liquibase 3.6.3):

liquibase.bat^
    --changeLogFile=databaseChangeLog.oracle.sql^
    --driver=oracle.jdbc.OracleDriver ^
    --url=jdbc:oracle:thin:@//localhost:1521/orcl ^
    --username=uat ^
    --password=uat ^
    diffChangeLog ^
    --referenceDriver=oracle.jdbc.OracleDriver ^
    --referenceUrl=jdbc:oracle:thin:@//localhost:1521/orcl ^
    --referenceUsername=test ^
    --referencePassword=test ^

Problem

I did run this query to genereate changelogFile in .sql format ``` liquibase --driver=com.mysql.jdbc.Driver --classpath=mysql-connector-java-5.1.24-bin.jar --changeLogFile=test_diff.sql --url="jdbc:mysql://localhost/provision" --username=root --password=** diffChangeLog --referenceUrl=jdbc:mysql://localhost/provision_old --referenceUsername=root --referencePassword=*** ``` I get following error ``` Liquibase Update Failed: No serializer associated with the filename or extension 'sql' SEVERE 5/2/13 12:50 PM:liquibase: No serializer associated with the filename or extension 'sql' java.lang.RuntimeException: No serializer associated with the filename or extension 'sql' ``` Is it possible to generate changelogfile in .sql formate?

Original source