Dynamic Table Creation based on Document Type Definition of XML
I have an XML document (1 GB in size) with a Document Type Definition. I need to load the data into an sql table, but the challenge is the table structure must be created during runtime, and it depends upon the .dtd file. The .dtd file changes from customer to customer. I am new to XML. I can provide the XML and .dtd if its required. Thanks a ton.
There is no simple, magic, way to do this. In order to accomplish what you're after, you need to understand the dtd files and how they relate to the required SQL table(s). Only after you have a reasonable grasp on this can you expect to generate tables on the fly from your document.