Use this window to select the tables that you want to transform
into a new XML schema model.
You can generate an XML schema model from source files that might
be located in multiple databases. You can use this XML schema model as a target
in the mapping editor and in the Discover Relationships wizard.
When
the source files are transformed into a new XML schema model, the original
table, column, and schema names are preserved. Also, the primary keys and
foreign keys on the columns are preserved. If the source tables are from multiple
databases, a target database object named "New" is saved in the XML schema.
The XML schema model that you create does not retain any connections to the
original SQL model objects. The new XML schema model is independent from the
XML schema of the original source.
- Select objects
- Select the tables that you want to transform into a new XML schema model
by selecting the appropriate check boxes. Expand the tree to view the available
tables. When you select a table, the schema and database for that table are
also selected. If you select all of the tables for a schema and database,
then the background color of the check box is white. If you select only some
of the tables, then the background color of the check box is gray. If you
deselect a schema or database, then all of the objects associated with that
schema or database are also deselected.
- XML schema file name
- Type a file name for the new XML schema model. The file extension must
be .xsd. The default file name is Schema.xsd. The .xsd file is saved in the XML
Schemas folder.