You can use the mapping model to find or document relationships, and to generate statements that query or manipulate your data sources by using these relationships. You can create a mapping model with the Mapping Editor wizard and modify the model with the mapping editor. You can specify source and targets when you create the mapping model using the Mapping Editor wizard, or you can add sources and targets to the existing mapping model with the mapping editor.
You cannot generate scripts if your mapping model has more than one source data model file.
To create a mapping model:
The mapping editor displays the source data models that you selected on the left side of the editor. The source can contain one or more source files that can contain multiple schemas. The mapping editor displays the single target file that you selected on the right side of the editor. The target file can contain multiple schemas.
The mapping models that you create are stored under the current data design project. The contents of the data design project are physically stored on a file system folder on your client machine. The mapping model is stored in the .msl file. You can save or open an .msl file in any data design project. When you open an .msl file it opens inside the mapping editor. You can have multiple mapping editors open at the same time but only one editor is visible at a time. When you exit the application, you are asked to save any uncommitted changes.
The advantage of saving objects on the local workspace is that you can work with your .msl mapping model in a disconnected mode. Save the .msl file in the active mapping editor by clicking Data Project Explorer view by clicking . The name of an msl file must be unique within the data design project.
. You can save to any data design project within the