DSXchange

Have a project where they need to take and generate the schema from the XML: XML to DDL or something like that.

Beyond the initial XML-to-DDL, this XML will likely change and grow over time so they are looking for something that can do a diff of the schema and (hopefully) manage the DDL to update the schema as the XML changes.

I've done some searching and found a few things worth investigating but thought some of you here may have already done such a project and have some input.

I wrote a job eons ago - to dump table definitions in various formats - that was adapted by Kim Duke into a function called KgdCreateDdlMetadata; information about it can be found here and the function itself can be downloaded from Kim's web site