Filter
Top Products
Chapter 5 Exchanging data with databases supporting XML
XSM User's Guide 225
The annotated schema appears in the editor window.
Note the SQL namespace (with the sql prefix) and the SQL annotations
for tables (sql:relation), columns (sql:field) and reference
(sql:relationship).
18 Click Close in the Result dialog box.
Reinforcing mapping with extended attributes
If you want to modify or reinforce the mapping resulting from the the XML
Builder Wizard, you can define extended attributes for XML objects.
Extended attributes are available from the Microsoft SQL Server extended
model definition attached to the mapped XML model. If the element and
attribute names match with the table and column names, you do not need to
define extended attributes for XML objects.
You could generate an annotated schema without a PDM and the XML
Builder Wizard, only through extended attributes, but it would not be the
easiest way to proceed.
Caution
The following procedure assumes you have an XML model open in the
workspace, targeted with XSD or XDR, mapped with a PDM, and linked
to the Microsoft SQL Server extended model definition. (See Mapping
XML objects to PDM objects)