問題描述
有什么東西可以幫助我將 XSD 轉(zhuǎn)換為 SQL 關(guān)系表嗎?XSD 相當(dāng)大(無論如何在我的世界中)，如果有什么東西推動(dòng)我前進(jìn)而不是從頭開始，我可以節(jié)省時(shí)間和無聊的打字.
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 的標(biāo)準(zhǔn)化/本地化格式.
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 會(huì)花費(fèi)你一些錢.
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.
有趣的是，開發(fā)人員使用了一個(gè)非常聰明的技巧，即使用 XSLT 轉(zhuǎn)換從 XSD 文件創(chuàng)建 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...
剛剛發(fā)現(xiàn)這個(gè)問題之前問過 這里...
Just found this question asked previously here...
這篇關(guān)于將 XSD 轉(zhuǎn)換為 SQL 關(guān)系表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！