RE: [xsl] Generating database objects from XML file

["Clapham, Paul" <pclapham@xxxxxxxxxxxxx>]

All of those databases support standard SQL.  Wouldn't a database creation
script consisting of a series of "Create Table" commands and the like be
quite sufficient, without needing to drag in XML?

PC2

-----Original Message-----
From: Tako Molanus [mailto:molanust@xxxxxxxxx]
Sent: February 5, 2001 23:59
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] Generating database objects from XML file


Hi there,

I am working on a project that is probably going to be
based on an Oracle database, but this choice of
database might change in the nearby (or far off)
future to any other database, like PostGress, MySQL or
SQLServer.

Because of this uncertainty, I'd like to define the
tables/indexes/constraints etcetera that I need for my
database in a dynamic way.

XML seems like a good idea, and I could use XSL to
generate the necessary database creation scripts.


I was wondering whether there is some ready-to-use
stylesheet for this, which allows me to make an XML
file and which can than generate the necessary scripts
for either an Oracle database, or a PostGress
database, or any (?) other database.

Do you know of such a tool?


Thanks in advance,


Tako Molanus


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list