-
Converting XSD to Oracle DDL
What are the best tools for doing this? what are their strengths and weaknesses if we were working on a large project?
-
-
-
It is easy to generate XSD from an Oracle table [DBMS_XMLSCHEMA.generateSchema], but the reverse is not as straight-forward. You might want to check out Altove XmlSpy 2006 ; it has the capability to create relational DB schemas from XSD. There is also XMLFox, though cannot vouch for it not having used it myself.
As this conversion would likely be a one-time activity, as long as the tool gives you accurate results you should be fine with any?
Not sure of your business requirements but while designing your system I hope you have given thought to storing the XML data as-is in the database, as opposed to changing it to relational form.
Here's a discussion that sheds light on the pros and cons of both approaches:
http://asktom.oracle.com/pls/ask/f?p...:2957707652801,
-
We were taking a look at XMLSpy. Maywe we should see the freeware too.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|