Thanks Nathan. sorry for a bit late reply. I could work with different
schema requirement with this solution.
Thanks,
Pradnya
On Tue, Mar 3, 2009 at 5:53 PM, Voxland, Nathan <
nvoxl...@intelligentinsites.com> wrote:
> I think the easiest way is to use the “parameter” functionality.
> http://www.liquibase.org/manual/changelog_parameters
>
>
>
> You can make your changeset as schemaName=”${schema}” and then pass the
> schema you want into liquibase.
>
>
>
> Nathan
>
>
>
> *From:* Pradnya Gawade [mailto:pradnya.gawa...@gmail.com]
> *Sent:* Tuesday, March 03, 2009 12:20 PM
> *To:* liquibase-user@lists.sourceforge.net
> *Subject:* [Liquibase-user] liquibase: specify schema name specific to
> database
>
>
>
> Hi,
>
> I am trying to have a common changeLog xml file for two databases Postgres
> and Oracle. Probably I have found the way to manage all other database
> specific syntax in the xml file except the schema names.
> I want to have different schema name for oracle and postgres as
> 'schemaName' attribute inside <createTable> tag . Is there any simple way to
> do this? I thought about using the <preConditions> tag to contain different
> <createTable> tag for different database (with the difference of schema name
> specific to database inside <createTable> tag) but this do not look to be
> the optimum way to me as there are so many tables.
> Could any one suggest some better way if it is there. Thanks in advance.
>
> -- 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
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@lists.sourceforge.net
> 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
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
