A new topic, 'Multiple schemas: multiple LB sets?', has been made on a board
you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=510.new#new
The text of the topic is shown below:
Hi,
We are working on an application that is subdivided into several licensable
sub-applications.
There is one central base application, that contains some metadata on all the
sub-applications. Apart from that sub-applications are not allowed to refer any
other sub-application but BASE.
Up until now we had a separate directory structure for each sub: BASE/install &
BASE/update for the BASE app, FIN/install & FIN/update for the FIN sub, etc.
Working in dev and propagating changes to test when changes occurred went fine:
we would run the updates from BASE, followed by the other subs.
However, when doing a fresh install after some time, we ran into the following:
01/01/2010: in FIN a table is added. Info about that table is inserted into
BASE.TABLES
01/03/2010: in BASE.TABLES a column ind_backup was added. An sql is provided as
part of this script that updates existing rows. Finally the column is made
mandatory
01/04/2010: in FIN a table is added. Info about that table is inserted into
BASE.TABLES, including a value for the new (mandatory) column
This scenario works out ok when run in this order (as we do on dev & test).
However, when run as a fresh install, the order will be:
- First run all BASE scripts
- then run all other scripts (per sub-app)
So, this means that the mandatory column is created before the first insert on
BASE.TABLES takes place.
The 01/01/2010 insert in turn fails, because at that time the mandatory column
did not exist.
So, my questions are:
Is this a familiar scenario?
Is there a smart solution for this that we are overlooking?
Should we go into a single LB structure and explicitly define the schema in
every changeset?
Thanks in advance for looking into this,
Frank
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
