Hi,
I tried 'diffTypes' option on command prompt but it was not successful. Only
*--diffTypes='data'* syntax worked without any error on command line but
just puts <databaseChangeLog> tag starting and nothing inside it in the
generated xml file. I am pasting the my command line trials below, last
command prints the output of *--diffTypes='data'* on console. Could you
please provide the example of command using this diffTypes parameter which
will work out exactly?:
*C:\Program Files\PostgreSQL\8.2\bin>java -jar
C:\Pradnya\Softwares\liquibase\liq
uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
--classpat
h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
--url="j
dbc:postgresql://localhost:5432/openclinica" --username=clinica
--password=
clinica
--changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
a.xml --diffTypes=data generateChangeLog
Migration Failed: For input string: "f"
C:\Program Files\PostgreSQL\8.2\bin>java -jar
C:\Pradnya\Softwares\liquibase\liq
uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
--classpat
h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
--url="j
dbc:postgresql://localhost:5432/openclinica" --username=clinica
--password=
clinica
--changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
a.xml --diffTypes=DATA generateChangeLog
Migration Failed: For input string: "f"
C:\Program Files\PostgreSQL\8.2\bin>java -jar
C:\Pradnya\Softwares\liquibase\liq
uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
--classpat
h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
--url="j
dbc:postgresql://localhost:5432/openclinica" --username=clinica
--password=
clinica
--changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
a.xml --diffTypes="data" generateChangeLog
Migration Failed: For input string: "f"
C:\Program Files\PostgreSQL\8.2\bin>java -jar
C:\Pradnya\Softwares\liquibase\liq
uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
--classpat
h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
--url="j
dbc:postgresql://localhost:5432/openclinica" --username=clinica
--password=
clinica
--changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
a.xml --diffTypes='data' generateChangeLog
*(above command which worked is run below withoput mentioning the
changeLogFile, so that output will be on the command primpt)*
C:\Program Files\PostgreSQL\8.2\bin>java -jar
C:\Pradnya\Softwares\liquibase\liq
uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
--classpat
h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
--url="j
dbc:postgresql://localhost:5432/openclinica" --username=clinica
--password=
clinica --diffTypes='data' generateChangeLog
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9";
xmlns
:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="
http://www.
liquibase.org/xml/ns/dbchangelog/1.9
http://www.liquibase.org/xml/ns/dbchangelog
/dbchangelog-1.9.xsd"/>
*
Thanks and Regards,
Pradnya*
*
On Wed, Feb 25, 2009 at 9:04 PM, Voxland, Nathan <
[email protected]> wrote:
> If you run "liquibase --help" it will give you the options available from
> the command line. There should be a --diffTypes option or something
> similar.
>
> Nathan
>
>
>
> On Feb 25, 2009, at 6:11 PM, "Pradnya Gawade" <[email protected]>
> wrote:
>
> Thanks Ben for the quick reply.
> Presently I am only using the command line for liquibase and will be
> integrating the liquibase with web application developed using spring
> framework. I am not using Ant for liquibase but if there is no other way to
> get the xml with data contents, I will try Ant for the same. Please let me
> know if some thing is possible through command line or even maven.
>
> Thanks and Regards,
> Pradnya
>
>
>
> On Wed, Feb 25, 2009 at 6:36 PM, Ben Wolfe < <[email protected]>
> [email protected]> wrote:
>
>>
>> Yes, there is a way. With the ant task you can set diffTypes="data" to
>> just give you the rows in the generated xml. I'm not sure what the
>> argument is for the jar file though. I can't find that in my command
>> history or in the jar help text.
>>
>> Ben
>>
>> Pradnya Gawade wrote:
>> > Hi,
>> >
>> > I am new to liquibase and need some help.
>> >
>> > I want to get the database state with schema and database contents
>> > into a chageLog xml file. I want to use this xml at some other place
>> > to replicate the exact original database.
>> > I could get the database schema with 'generateChangeLog' command but I
>> > don't know how can I get the database contents in xml file. Writing
>> > the data insert statements manually will be time consuming as there
>> > are large number of tables with initial application configuration data
>> > in the original database.
>> > Is it possible to get such xml with database contents?
>> >
>> > I also tried 'diff' command between the original and newly created
>> > database after migrating the schema xml . but it do not show me the
>> > data content differences. I read in the liquibase documentation that
>> > 'diff' compares Data differences (limited) but I don't see that in the
>> > diff result.
>> >
>> > Thanks and Regards,
>> > Pradnya
>> > ------------------------------------------------------------------------
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Open Source Business Conference (OSBC), March 24-25, 2009, San
>> Francisco, CA
>> > -OSBC tackles the biggest issue in open source: Open Sourcing the
>> Enterprise
>> > -Strategies to boost innovation and cut costs with open source
>> participation
>> > -Receive a $600 discount off the registration fee with the source code:
>> SFAD
>> > <http://p.sf.net/sfu/XcvMzF8H>http://p.sf.net/sfu/XcvMzF8H
>> > ------------------------------------------------------------------------
>> >
>> > _______________________________________________
>> > Liquibase-user mailing list
>> > <[email protected]>
>> [email protected]
>> > <https://lists.sourceforge.net/lists/listinfo/liquibase-user>
>> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
>> CA
>> -OSBC tackles the biggest issue in open source: Open Sourcing the
>> Enterprise
>> -Strategies to boost innovation and cut costs with open source
>> participation
>> -Receive a $600 discount off the registration fee with the source code:
>> SFAD
>> <http://p.sf.net/sfu/XcvMzF8H>http://p.sf.net/sfu/XcvMzF8H
>> _______________________________________________
>> Liquibase-user mailing list
>> <[email protected]>
>> [email protected]
>> <https://lists.sourceforge.net/lists/listinfo/liquibase-user>
>> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
>
> _______________________________________________
> Liquibase-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> Liquibase-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
