问题描述
我有一组的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文件数据库表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!