tcm2sql
tcm2sql is a tool for generating SQL commands from a TCM static structure diagram (SSD).
Maintainer:
Current Version:
stable 0.9.2 (2006-10-18)
Details:
tcm2sql is a tool for generating SQL "CREATE" commands from a tcm static structure diagram (SSD) including constraints and foreign keys. It is also possible to diff two diagrams to update a database's structure.
Database diagrams can become quite large. This is a problem as tcm only allows about six pages and you probably get lot's of crossed lines. So it is possible to split diagrams into several files while still creating one connected database structure.
Changes between 0.9.1 and 0.9.2:
- Restructured renderer classes to make it easier to write renderers for other database managenemt systems.
- Better handling for serials and bigserials: Now they are always written as integer with default + creation of sequence. (This makes updating of tables possible which have serial columns.)
- Added commandline option --no_views to not generate views for the tables.
- Made usage help a bit nicer.
Locations:
- via FTP: tcm2sql-0.9.2.tar.gz
- older versions can be found at ftp://ftp.gocept.com/tcm2sql/
- development Subversion:
svn co http://svn.gocept.com/repos/gocept/tcm2sql/trunk tcm2sql
Deutsch
English
gocept attends SYSTEMS-world in Munich
