You can register additional XML schemas with a database and later assign these schemas to individual XML fields of the database. In the XML Schema management for databases dialog box, these newly added XML schemas are marked new () in the list box, and must be confirmed before they are actually registered with the database's XSR repository.
Before you commit the changes to the database, you can view the XML schema in XMLSpy or change its description or decomposition properties in the dialog box.
All actions that you perform in the XML Schema management for databases dialog box are reported in the Report tab which works the same way as the Output window in DatabaseSpy.
After an XML schema has been successfully registered with the database, it appears in the XML Schemas sub-folder of the Online Browser.
To register an XML schema with the database:
1.In the XML Schema management for databases dialog box, select a database connection from the left drop-down list if no data source connection is active.
2.Click the Add Schema... button or right-click anywhere into the list box and select Add Schema... from the context menu. The standard Windows Open dialog box appears.
3.Browse to the location of the required XML schema file and click Open. The XML schema appears in the list of available XML schemas and a New icon indicates that this XML schema has not been committed to the database yet.
4.Optionally, double-click the file name of the XML schema and edit the name as desired.
5.Optionally, activate the Show details check box and enter a description for the XML file.
6.Optionally, activate the Decomp. check box or right-click the XML schema and activate the Decomposition option in the context menu to enable the XML schema for decomposition, if applicable.
7.Optionally, change the database schema in the DB schema column, if applicable.
8.Click the Commit changes button.
9.Click Close to exit the dialog box. If any changes have not been committed yet, a prompt appears, asking you whether you would like to commit or discard the changes.