Generate XML Schema window

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.

Feedback