RE: Generating database objects from XML file

Maybe there are not many differences in a simple table
creation script, but in an Oracle database you would
want to define a storage clause and tablespace etc.

Besides, I believe the datatypes are different on the
different databases.

And what about indexes, foreign keys etc?

And another thing: for every object we create in the
database, we also want to have a drop object statement
available. This means, when using .sql files, a lot of
files which have to be maintained.
If al this could be generated at once from an XML
file, this would save us a lot of trouble.

Tako


--- "Clapham, Paul" <pclapham@xxxxxxxxxxxxx> wrote:
> 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:  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
> 
> 
>  XSL-List info and archive: 
> http://www.mulberrytech.com/xsl/xsl-list
> 
>  XSL-List info and archive: 
> http://www.mulberrytech.com/xsl/xsl-list
> 


__________________________________________________
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