RE: [xsl] Generating database objects from XML file

Subject: RE: [xsl] Generating database objects from XML file
From: Tako Molanus <molanust@xxxxxxxxx>
Date: Tue, 6 Feb 2001 22:53:18 -0800 (PST)
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.


--- "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: [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
>  XSL-List info and archive: 
>  XSL-List info and archive: 

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.

 XSL-List info and archive:

Current Thread