Is it possible to write a generic parser for xsd/xml files?

Question

Programming

Is it possible to create a program that creates a database based on xsd / xml file, for example in ms sql and writes information from xml there? Those. We do not know in advance what will be at the entrance. Or is this task a utopia? If so, please describe the main points and limitations that make it impossible to create such a program.

Answer 1

How do you plan to take information about types? Limits on the length of strings, for example. Nullable fields, default values?
If the xml contains such information in a separate block (let's call it "header"), everything is relatively simple. We parse the header, form a request for the presence of a database / table, if not, we create it, if there is, we compare the structures. Then we parse the records, constructing a banal Insert. You can take into account the presence of files with such keys, then we construct the if exists then insert else update construct.
Perhaps something like EF's CodeFirst will do. At the very least, there must be a perverted way.