Hi Dmitriy! I very often use a great CASE tool for DB Engineering called DB-MAIN. www.db-main.be or http://www.info.fundp.ac.be/~dbm/
It implements a schema transformation approch which can transform a entity-relationship schema to SQL DDL, DTD, and others. HTH Michael ------------------------------------------------------------ Michael Fontan [EMAIL PROTECTED] Database Administrator -----Original Message----- From: Dmitriy Bocharov [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 5:15 PM To: JDJList Subject: [jdjlist] SQL-XML-SQL Hello all. Just simple question. Does anybody know the flexible and power tool and/or API for describing the SQL in terms of objects, building the element tree of the SQL, mapping it to the some XML schema and finally transforming the mapped SQL to the other SQL notations, for example to the PL-SQL? So the start point is: we have to generate the ANSI SQL from some description. And finally we have to transform it to the some more specific SQL, for example in PL-SQL. Any links to the sources and suggestions would be very appreciated. Dmitriy Bocharov Aplana Software Inc [EMAIL PROTECTED] To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
