Re: Re: xsd2db

On Thu, 2003-02-27 at 15:52, Manuel Lemos wrote: > Hello, > > On 02/27/2003 09:52 AM, Sandro Zic wrote: > > I did a proof of concept converting a XML schema definition to MySQL CREATE > > TABLE statements with XSLT. > > > > http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/zzoss/zzoss/utils/xsd2db/ > > > > Of course, the current implementation does not handle all aspects of MySQL > > table definitions. > > > > The purpose is to have several xsd2db stylesheets for various RDBMS, and LDAP. > > This would need some extra schema being introduced like for DB2: > > > > http://www7b.software.ibm.com/dmdd/library/techarticle/0209lima/0209lima.html > > Also, how to best handle nested elements of a XSD in a RDBMS is yet an open > > question to me. > > > > I sent this to pear-dev, because maybe this is of interest to PEAR::MDB? > > Basically you seem to want to replicate a functionality that > Metabase/MDB already provide and works well. What would be the advantage > of using XSLT for the same purpose? > > > > Does anyone know of similar XSLT stylesheets serving the same purpose? > > Personally, I only see disadvantages in resorting to XSLT to generate > SQL scripts to install and update database schemas, especially when > there is already a working and tested PHP solution for that purpose. > Maybe I am missing something here. This would be of interest to Metabase / MDB if the XSLT transformed XSD into a Metabase / MDB xml data definition file (and another to go the other way) rather than SQL table defs for specific databases. Presumably XML schema is used in database/ application design tools which we can then interoperate with ? Paul > > -- > > Regards, > Manuel Lemos -- ----------------------------------------------------------------- Paul Cooper | Tel: 0121 331 7858 Software Manager | Fax: 0121 331 7859 Digital Media Centre | mailto:pgc@design4media.co.uk University of Central England | http://www.design4media.co.uk Birmingham, B4 7DX | -----------------------------------------------------------------