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>
