Are you thinking that you would have a pom file for Table A that says
this version (1.1.2) of Table A depends on version 1.1.3 of Table B,
version 1.1.2 of Table C and version 1.1.0 of Table D?
I am not sure how you would pick out a starting point since some of the
dependencies would be bidirectional and your DBA might get the same
upgrade script several times but would only want to execute it once.
We use Hibernate so that we have a much more integrated
problem/situation. A new table structure generates a lot of Java code
that is tied to the whole set of tables from POJOs to DAOs. It also
generates a complete table structure upgrade for the database for the
version change.
We have to manually build and data transformations that are required but
they are still tied to the single version being upgraded (1 script takes
the data from a 1.1.2 database and makes a 1.1.3 database out of it)
I am not sure how automatic your scheme can become. It would seem that
other tools from the database side might be more helpful.
Ron
On 21/02/2011 12:40 PM, Craig Boyd wrote:
Hello All,
I am trying to work my way through managing DDL and versioning it. I am
not a developer so some of my knowledge is a little limited. We are
trying to figure out the best way to manage our development DDL. The
path we are going down is placing each database object in its own file
and placing those files under version control. The painful part is
managing the dependencies. For example, suppose I have a change to a
table that requires it to be dropped and recreated. That table has
several dependencies (indexes, foreign key constraints, etc...) that go
away when the table is dropped. I would like to be able to pull out the
table and its dependencies from the source control system using Maven to
manage those dependencies. I do not need the DDL actually executed
(like the SQL plug-in for Maven does), I just need the DDL files copied
to an output directory so that we can pass them off to the DBA for
execution.
We are using SVN for version control.
Is this doable or am I looking in the wrong place?
Thanks,
Craig
</pre><font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to
which it is addressed and<br>may contain confidential and/or privileged material. If the reader of this message is not the
intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of
this message including any attachments is strictly prohibited. If you are not<br>the intended recipient, please contact the sender and delete the
material from any computer.<br><pre>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
