资 源 简 介
Set of tools for automatization storing of oracle DDL schema in SVN.
The contents of the set
scheme2ddl - command line utility for export oracle schema in set of ddl scripts. provide lot of configurations via basic command line options or advanced XML configuration
additional scripts (sh, bat and ant) for automated retrieving scheme ddl and storing it in svn
Benefits
Using of SVN (or other VCS tools) for storing changes of oracle scheme is great idea.
Simple scenario as 2-step script
exp user/password@sid owner=owner file=file.dmp log=logfile.log rows=nimp user/password@sid full=y file=file.dmp show=y log=script.log
is work, but outbut is ugly formatted scripts in one file, with lot of additional information.
scheme2ddl give ability to filter undesirable information, separate DDL in different files, pretty format output.
How