I am creating an annual XML document to submit to a government agency. They have published an XSD Schema. Our data is in SQL Server 2000.
I need some way of associating columns from tables in SQL Server 2000 with the elements from the XSD schema to produce a valid XML document.
It looks like I could use XMLSpy or Stylus Studio, but I think there must be some way of doing it in Visual Studio 2005. Does Visual Studio 2005 have tools to help me do this Can anyone direct me to a WebCast or part of the documentation that would dexplain I can do this
(P.S. If you are curious, this is for the CDFI CIIS)
Can Visual Studio map SQL Server to XSD Schema?
Paul J.M. Settels
bjornstoro
SQLXML has support for mapping between SQL Server and XSD using annotations in the XSD schema. There is no tool to visualize the mapping. Here is an overview of mapping schemas:
http://msdn2.microsoft.com/en-us/library/ms171870(SQL.90).aspx
This article is about SQLXML 4, but also applies to SQLXML 3 which is available on msdn:
http://www.microsoft.com/downloads/details.aspx FamilyID=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en