Chapter 6 Working with XML and Databases

Reinforcing SQL Server mappings with extended attributes

The Microsoft SQL Server extended model definition allows you to modify or reinforce the mapping resulting from the XML Builder Wizard via extended attributes.

Note   If element and attribute names match table and column names
If the element and attribute names match the table and column names, you do not need to define extended attributes for XML objects.

Steps To attach the XEM:

  1. Select Model→Extended Model Definitions to open the List of Extended Model Definitions
  2. Click the Import an Extended Model Definition tool to open the Extended Model Definition Selection dialog box, click the XML in Database tab, select Microsoft SQL Server, and click OK in order to attach it to the model.

Note   Annotated schema preview
By clicking the Preview tab of the model property sheet, you can have a preview of the annotated schema.

 

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