How to generate changlogFile in.sql format?

Question

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?

Answer 1

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 ^

Answer 2

Try with this param:

--changeLogFile="./changelog.mysql.sql"

Can refer here.