Chapter 6 Working with XML and Databases

Mapping database objects to an XML schema via the XML Builder Wizard

You can create an XSM to generate an annotated schema from a PDM via the XML Builder.

To generate an annotated schema by mapping through the XML Builder Wizard:

1. Open a PDM targeted with the appropriate DBMS, and select Tools→XML Builder Wizard to open the XML Builder Wizard.
2. Specify whether to create a new or work with an existing model, and then click Next to go to the Tables and Views Selection page.
3. Select the tables and views from which you want to generate the schema, and then click Next to go to the XML Hierarchy Design page.
4. Build your hierarchy by dragging and dropping tables and/or columns from the left pane to the right pane or by using the tools above the panes:
   
   
   For detailed information about using the wizard, see "Generating an XSM from a PDM via the XML Builder Wizard" in the Working with Data Models chapter of the Data Modeling guide.
5. Click Finish to generate the XML model:
   
   
   In the case of an existing XML model, the generated elements appear alongside the existing elements.
   
   
      Extended model definitions
   The SQL/XML extended model definition is automatically attached to the generated XML model.
   You can attach the XML Document extended model definition to generate a simplified XML file that will help you understand the annotated schema. (See Note in step 11)
   
   

Copyright (C) 2008. Sybase Inc. All rights reserved.