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.
You must create a data design project in the Data Project Explorer
and import at least one .dbm file to the data design project.
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.
To generate an
XML schema model:
- In the data design project, select one or more .dbm files in the Data
Models folder.
- Right-click and select Generate XML Schema.
The Generate XML Schema window opens.
- Select the tables that you want to transform into a new XML schema
model.
- 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.
The new XML schema model is created and saved in the XML
Schema folder in the data design project.