将 XSD 转换为 SQL 关系表

问题描述

有什么东西可以帮助我将 XSD 转换为 SQL 关系表吗?XSD 相当大(无论如何在我的世界中)，如果有什么东西推动我前进而不是从头开始，我可以节省时间和无聊的打字.

Is there something available that could help me convert a XSD into SQL relational tables? The XSD is rather big (in my world anyway) and I could save time and boring typing if something pushed me ahead rather than starting from scratch.

如果您想查看，XSD 位于这里.这是一种交换 MSDS 的标准化/本地化格式.

The XSD is here if you want to have a look. It's a standardized/localized format to exchange MSDS.

推荐答案

Altova 的 XML Spy具有从 XSD 文件生成 SQL DDL 脚本的功能.不过 XML Spy 会花费你一些钱.

Altova's XML Spy has a feature that will generate SQL DDL Script from an XSD file. XML Spy will cost you some money though.

有趣的是，开发人员使用了一个非常聪明的技巧，即使用 XSLT 转换从 XSD 文件创建 DDL 脚本.他们在 here 和 这里.

Interestingly enough, a developer used a really clever trick of using an XSLT translation to create the DDL script from an XSD file. They have outlined it in two parts here and here.

我可能必须自己尝试一下以备将来使用...

I might have to try this out myself for future use...

刚刚发现这个问题之前问过 这里...

Just found this question asked previously here...

这篇关于将 XSD 转换为 SQL 关系表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！