Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I create database tables from XSD files?

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.

like image 590
Oded Avatar asked Sep 26 '08 10:09

Oded


People also ask

What is XSD in database?

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.

What can you do with XSD files?

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.


1 Answers

There is a command-line tool called XSD2DB, that generates database from xsd-files, available at sourceforge.

like image 126
Spoike Avatar answered Oct 11 '22 01:10

Spoike