Generating an XML Schema

You can select tables that might be in multiple databases and transform the tables into one new XML schema model. You can use this XML schema model as a target in the mapping editor and in the Discover Relationships wizard.

Before you begin

You must create a data design project in the Data Project Explorer and import at least one .dbm file to the data design project.

About this task

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.

Procedure

To generate an XML schema model:

  1. In the data design project, select one or more .dbm files in the Data Models folder.
  2. Right-click and select Generate XML Schema. The Generate XML Schema window opens.
  3. Select the tables that you want to transform into a new XML schema model.
  4. Type a file name for the new XML schema model, and click OK. The file extension must be .xsd. The default file name is Schema.xsd.

Results

The new XML schema model is created and saved in the XML Schema folder in the data design project.

Feedback