This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Generating database objects from XML file
- To: xsl-list at lists dot mulberrytech dot com
- Subject: RE: [xsl] Generating database objects from XML file
- From: Tako Molanus <molanust at yahoo dot com>
- Date: Tue, 6 Feb 2001 22:53:18 -0800 (PST)
- Reply-To: xsl-list at lists dot mulberrytech dot com
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@core-mark.com> 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@yahoo.com]
> Sent: February 5, 2001 23:59
> To: xsl-list@lists.mulberrytech.com
> 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:
> 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