How do I convert an XSD into an Oracle schema / database structure?
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?
ASKER
I didn't create the XSD, it was given to me. I am viewing it in Visual Studio 2010.
Alternative # 1 :
You can use XSD2DB to do that http://xsd2db.sourceforge.net/
Alternative # 2 :
SQLXMLBULKLOAD : http://blogs.msdn.com/b/monicafrintu/archive/2007/06/12/how-to-create-tables-in-a-database-using-an-xsd-schema-and-sqlxmlbulkload.aspx
Alternative#3:
Here are various options discussed which might be helpful to you.
http://stackoverflow.com/questions/138575/how-can-i-create-database-tables-from-xsd-files
You can use XSD2DB to do that http://xsd2db.sourceforge.net/
Alternative # 2 :
SQLXMLBULKLOAD : http://blogs.msdn.com/b/monicafrintu/archive/2007/06/12/how-to-create-tables-in-a-database-using-an-xsd-schema-and-sqlxmlbulkload.aspx
Alternative#3:
Here are various options discussed which might be helpful to you.
http://stackoverflow.com/questions/138575/how-can-i-create-database-tables-from-xsd-files
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you can give name of this tool it would be easier.