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.