Generate DB schema and load data based on XML file?

Question

We have a large XML file with lots of data relationships and lots of data. Is there a way to generate a DB schema based on the relationships and then load the data into the schema?

mindas · Accepted Answer · 2009-12-10 17:32:35Z

1

Just write an XSLT which would generate schema in SQL.
Then write another XSLT which would generate INSERT statements.

answered Dec 10, 2009 at 17:32

mindas

26.8k15 gold badges103 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marco Gralike · Accepted Answer · 2010-01-13 22:12:40Z

0

Stuff like this can be found on the Oracle OTN XMLDB Forum. This one is mentioned here: Generate XML Schema from oracle tables

answered Jan 13, 2010 at 22:12

Marco Gralike

11 bronze badge

Collectives™ on Stack Overflow

Generate DB schema and load data based on XML file?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related