Set of tools for automatization storing of oracle DDL schema in SVN.
- 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
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=n
imp 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.
Java must be installed on your computer. For exporting oracle scheme you must provide
- DB connection string
- output directory Usage example. Command
java -jar scheme2ddl.jar -url scott/tiger@localhost:1521:ORCL -o C:/temp/oracle-ddl2svn/
will produce directory tree
views/
view1.sql
view2.sql
tables/
table1.sql
functions
/f1.sql
More command line options
java -jar scheme2ddl.jar -help
- First, get list of all user_object to export
select * from user_objects where object_type in ()
- then applying dbms_metadata.set_transform_param
- for every user object invoke dbms_metadata.get_ddl and dbms_metadata.get_dependent_ddl
- print every ddl to separate file grouped in folders like tables, views, procedures etc
advanced configuration provided in scheme2ddl.config.xml,