I am not very good at XML or XSD but trying to understand it better and looking for an adhoc solution to population of a database. I have an XML File that sets the tablename, primary field, and some additional fields for a table with values. What I need is to replace a current XSD in a program (that knows the database schema) with otherXSD that will take the new xml file and populate a database based on the what is found in the XML (table name and fields) File and not pre-determined in the XSD File.
In the code the entity type is table and in this case UNITS, keyname is the primary key field and there is a description field.
Am I barking up a bad tree here or is it possible to have a generic XSD that reads an XML and will load in a data set of records.
<?xml version='1.0' encoding='ISO-8859-1' ?>
xmlns:xsi = 'http://www.w3.org/2001/XMLSchema-instance'
xmlns:xsd = 'http://www.w3.org/2001/XMLSchema'
<SimpleQuery name='Create Units' workflow='Create'>
<Entity type='units' keyname='g'>
<Entity type='units' keyname='kg'>