XSD 到 SQL Server 的转换

问题描述

我有一个关于 SQL Server 的 SQLXML 的问题.

I have a question in regards to the SQLXML for SQL Server.

我的任务是转换一个 XSD 文件，使其神奇地成为"SQL Server 数据库中的表.我到处环顾四周，在我可能找到的所有链接上，但没有点击.一切都像是我需要实现的半步.

My assignment is to convert an XSD file so that it magically "becomes" tables in the SQL Server database. I've looked around everywhere, on all the links I could possibly find, but nothing clicks. Everything is like a half-step of what I need to achieve.

我对 Visual Studio 不太熟悉，除了运行数据库查询和人们喜欢在 SQL Server 数据库中做的所有事情之外，我没有做太多其他事情.除了 XML.

I am not too familiar with Visual Studio, haven't done much else than running database queries and all the stuff one likes to do in a SQL Server database. Except for XML.

我认为 Microsoft 的 MSDN 中的 SQLXML 将是一个很好的工具(而且我相信它已经安装了).

I figured that SQLXML from Microsoft's MSDN would be a good tool to have (and I believe it's already installed).

任何提示或解决方案?

谢谢.

推荐答案

没有魔法，因为它是家庭作业/学习，我不会详细说明如何自己做，但是如果您将研究转向 SQL 的批量加载功能它似乎正是您所需要的.

There's no magic involved, and as it's homework/study I won't detail how to do it myself, but if you direct your research towards SQL's Bulk Load functionality it would seem to be what you need.

阅读此文章 以获取简要的操作方法"指南.

Read this article for a brief "how to" guide.

或者这篇文章如何使用它的详细说明.

Or this article for a detailed description of how to use it.

这篇关于XSD 到 SQL Server 的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！