SQLXML Mapping Schema Requirements:

    Microsoft .NET Framework 1.1 (free download from Microsoft)

    Microsoft SQLXML 3.0 (free download from Microsoft)

    Microsoft SQL Server 2000 (May work with version 7 but not tested with it) or MSDE

Program Overview

   The SQLXML Mapping Schema Generator is a visual tool that guides a developer through the process of designing a SQLXML mapping schema.  The program detects any SQL Servers connected to the workstation and permits the user to select the appropriate server.  It then steps the user through the process of selecting database, table(s), and column(s) containing the information required for the user's desired data object.

   Queries can be simple like "employee by id" or more complex parent-child queries like "order and order details by customer with conversion of part number to description".  The user may specify tag names for the resultant XML document or accept program defaults.

   The output of the program is two XML document:  the configuration file and an XSD mapping schema.  The configuration file is used for editing the schema if required at a later date.  The mapping schema is used with SQLXML to retrieve data from SQL Server.

   The application provides a routine for testing newly developed schemas against the actual server database and an edit routine for making schema changes.