I have a set of XSDs from which I generate data access classes, stored procedures and more.
What I don't have is a way to generate database table from these - is there a tool that will generate the DDL statements for me?
This is not the same as Create DB table from dataset table, as I do not have dataset tables, but XSDs.
Answer: The XSD (XML Schema Definition), is a database metadata generic Document Type Definition (DTD) that allows you to store XML documents. Once you define a document structured with a DTD, you can load it into the XSD schema and use it to validate the structure of XML documents.
An XSD file stores its contents as plain text in XML format, which means the files can be opened and viewed by any text editor and numerous other programs. However, if you want to edit an XSD file, you should use an XML editor, such as Microsoft XML Notepad, Bare Bones BBEdit, or SyncRO Soft oXygen XML Editor.
There is a command-line tool called XSD2DB, that generates database from xsd-files, available at sourceforge.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With