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
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format