Liquibase Command Line create diff changelog in sql

Question

I actually use Liquibase on windows in command lines, and I try to create an sql script that represent the diff between two databases. Unfortunatly I only get xml file in return. Can you help me ?

My command line :

liquidbase.bat 
   --driver=com.mysql.jdbc.Driver 
   --url=jdbc:mysql://localhost:3306/base1 
   --username=root 
   diffChangeLog 
   --referenceUrl=jdbc:mysql://localhost:3306/base2 
   --referenceUsername=root 
> test.sql

I've seen this similar question in an other forum but he didn't got a good answer (http://forum.liquibase.org/topic/convert-changelog-xml-file-into-sql-file). I've also seen some parameters for getting sql file from updateSQL cmd, but never for a diffChangeLog.

Example of the xml feedback :

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
    <changeSet author="user (generated)" id="1370443156612-1">
        <createTable tableName="test">
            <column name="a" type="INT"/>
        </createTable>
    </changeSet>
    <changeSet author="user (generated)" id="1370443156612-2">
        <addColumn tableName="articles">
            <column name="date_debut" type="TEXT">
                <constraints nullable="false"/>
            </column>
        </addColumn>
    </changeSet>

Thanks by advance.

possible duplicate of comparing databases and genrating sql script using liquibase — Mark O'Connor
– Mark O'Connor, Commented Jun 6, 2013 at 0:11

Ian Rogers · Accepted Answer · 2014-06-03 11:51:03Z

8

The diff command only provides a textual overview of the differences.

In order to get an SQL of the difference of a new (dev) and old database:

Use diffChangeLog to (temporarily perhaps) update your changelog by comparing two databases
Use updateSQL against the out-of-date database to show the sql commands that would be run to bring it up to date. Note the printed SQL will also contain commands needed by liquibase for administration.

You can then commit the new changelog with your code if the new/dev database is what you expect. Use changelogSync to make the new/dev database thinks it's been updated by liquibase.

answered Jun 3, 2014 at 11:51

Ian Rogers

6731 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lalit Kumar B · Accepted Answer · 2016-05-19 18:17:34Z

0

You're running the diffChangeLog command, I think you want the diff command? See Output Modes in the manual.

liquibase.bat 
  --driver=com.mysql.jdbc.Driver 
  --url=jdbc:mysql://localhost:3306/base1 
  --username=root 
  --referenceUrl=jdbc:mysql://localhost:3306/base2 
  --referenceUsername=root 
  diff
    > test.sql

edited May 19, 2016 at 18:17

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

answered Oct 8, 2013 at 16:51

Barn

96412 silver badges16 bronze badges

1 Comment

andPat Over a year ago

This is not true. the process is not so direct. No SQL compliant code is generated, only a textual overview like @Ian Rogers says.

Collectives™ on Stack Overflow

Liquibase Command Line create diff changelog in sql

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related