DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Converting XSD to Oracle DDL

  1. #1
    Join Date
    Jul 2006
    Posts
    11

    Question 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?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is XSD?

    Tamil

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    xml schema definition

    http://www.google.com/search?&q=xsd

  4. #4
    Join Date
    May 2006
    Posts
    12
    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,

  5. #5
    Join Date
    Jul 2006
    Posts
    11
    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
  •  


Click Here to Expand Forum to Full Width