Solved

How do I convert an XSD into an Oracle schema / database structure?

Posted on 2010-09-20
4
2,562 Views
Last Modified: 2013-12-18
I have a detailed XSD, expressed in several files connected together with includes.  I want to create a database schema or ERD (preferably for Oracle 10g) from those files using a tool.  What tool should I use, and what is the easiest way to create the schema, complete with tables and relationships?
0
Comment
Question by:EdwardAF
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:P2O
ID: 33721670
Which tool you created this XSD, that tool might have option to export this into schema table.
If you can give name of this tool it would be easier.
0
 

Author Comment

by:EdwardAF
ID: 33725176
I didn't create the XSD, it was given to me.  I am viewing it in Visual Studio 2010.
0
 
LVL 3

Expert Comment

by:P2O
ID: 33731813
0
 

Accepted Solution

by:
EdwardAF earned 0 total points
ID: 33855373
I went through the XSD manually and created a database structure from it.  This was very time consuming, but ultimately it was the only way to reliably create the ERD.  I could find no suitable tool to perform this task automatically.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now