Generating an Annotated Schema for Microsoft SQL Server 2000

Microsoft SQL Server 2000 is an XML-enabled database server, which supports annotations that can be used on XSD or XDR files, to map XML data to relational data.

An annotated schema is an XML file that allows you to store or retrieve data in an XML format, from relational databases supporting XML. An XML model allows you to generate an annotated schema (XSD or XDR) for SQL Server 2000.

  1. Map an XSM to a PDM. You can do this manually or by generating an XSM from a PDM (or a PDM from an XSM) but we recommend that you use the XML Builder Wizard (see Mapping database objects to an XML schema via the XML Builder Wizard)
  2. [if you do not use the wizard] Attach the SQL/XML extended model definition (see Attaching the SQL/XML extended model definition).
  3. [optional] Reinforce the mappings with extended attributes (see Reinforcing SQL Server mappings with extended attributes).
  4. Generate the annotated schema (see Generating the SQL Server annotated schema file).
Parent topic: Working with XML and Databases