Create Database Models From XML Schema (.xsd) using XSD2DB  

Posted by ReelTym

An opensource app that takes an XML Schema (.xsd) and generates a database and objects from it. I'm working on a CLR version that is strictly SQL Server and I can use from inside the database. An example use would be in auditing DML, create triggers on tables that grab the inserted data (select * from inserted for xml raw, elements, xmlschema, binary base64) and inserting that in an audit table. Since the xml contains the full table schema and the data inserted, you could then use that to create a history table and insert the data.

This entry was posted on Thursday, April 30, 2009 and is filed under , . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .