[ann] SST (SQL Schema Transformer) Project

Hi,

I've just released the first public release of SST[1] (SQL Schema
Transformer) which we have been using in production since a couple of
months. SST is a Common Lisp program that transforms an s-expression
based database schema format medium into appropriate SQL commands for
specified RDBMS. SST is capable of

* Dividing produced queries into logically separate (schemas,
tables, primary keys, foreign keys, indexes) files.
* Customized (and extendable) identifier formatters. (You can
adopt a naming scheme you prefer to name tables, indexes, etc.)
* FOREIGN KEY data type mismatch detection.
* Invalid FOREIGN KEY reference detection.
* Missing index detection for ON DELETE/UPDATE CASCADE references.
* FOREIGN KEY reference auto-completion. (You don't need to supply
column of the referenced table. SST infers it for you.)

See README[2] file further details.


Regards.

[1] http://www.cliki.net/sst
[2] http://www.students.itu.edu.tr/~yazicivo/files/sst.README.txt
.

Relevant Pages

  • Re: circular relationships ok?
    ... In other words, a database schema consisting of the relation schemata, ... and the foreign key constraints, ...
    (comp.databases.theory)
  • Re: Foreign key constraints from DB at runtime
    ... OleDbConnection object, and then use the GetOleDbSchemaTablemethod to get ... This will get you all the foreign key definitions inside the schemaTable ... I'm trying to detect them from the database's schema. ... foreign key constraints to other tables. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Business objects, subset of collection
    ... SQL works on not normalised data ... foreign key (vehicleid) references vehicle ... And who did the poor schema design, ...
    (comp.object)
  • Re: SST (SQL Schema Transformer) Project
    ... Transformer) which we have been using in production since a couple of ... SST is a Common Lisp program that transforms an s-expression ...     * FOREIGN KEY data type mismatch detection. ...
    (comp.lang.lisp)
  • Re: Diagrams
    ... How can I setup a foreign key while I'm designing a tabel??? ... > They are a simple ERD tool for visualising the schema of your database. ...
    (microsoft.public.sqlserver.server)