如何从XSD文件创建数据库表？ [英] How can I create database tables from XSD files?

问题描述

我有一组XSD，从中生成数据访问类，存储过程等。

I have a set of XSDs from which I generate data access classes, stored procedures and more.

我没有的办法是生成数据库表从这些 - 是否有一个工具，将为我生成DDL语句？

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?

这不同于从数据集表创建数据库表，因为我没有数据集表，但是XSD。

This is not the same as Create DB table from dataset table, as I do not have dataset tables, but XSDs.

推荐答案

商业产品：Altova的 XML Spy 。

Commercial Product: Altova's XML Spy.

请注意，这里没有一般解决方案。 XSD可以很容易地描述不映射到关系数据库的东西。

Note that there's no general solution to this. An XSD can easily describe something that does not map to a relational database.

虽然你可以尝试自动化这个，你的XSD必须设计一个关系数据库

While you can try to "automate" this, your XSD's must be designed with a relational database in mind, or it won't work out well.

如果XSD的功能不能很好地映射，您必须（1）设计一些映射然后（2）编写自己的应用程序将XSD翻译成DDL。

If the XSD's have features that don't map well you'll have to (1) design a mapping of some kind and then (2) write your own application to translate the XSD's into DDL.

到那里。出租工作 - 无开源。

Been there, done that. Work for hire -- no open source available.

这篇关于如何从XSD文件创建数据库表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！