SQL Server 2000 XML

SQL Server 2000 XML


SQLXML 3.0 XSD Mapping Schemas
With SQLXML 3.0, Microsoft includes XSD Mapping Schemas, an extension to the W3C XML Schema specification that allows an XML developer to specify how data should be mapped between relational tables (in SQL Server 2000) and XML documents.
XMLSpy® 2007 includes support for SQLXML XSD Mapping Schemas in the graphical XML Schema editor.
SQL Server 2000 Data Access
In addition, XMLSpy® 2007 includes full support for SQL Server 2000 data access through the extensive Database Import/Export interface.
This feature supports importing and exporting data between XML documents and relational tables, as well the conversion of a relational database schema into an XML Schema.