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:
- 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.
Results
The new XML schema model is created and saved in the
XML
Schema folder in the data design project.