我怎样才能创建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间谍

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屋！