This exercise teaches you how to generate and deploy SQL scripts
to represent the mapping.
To generate an SQL script based on the mapping model:
- Right-click myfirstmapping.msl mapping model and select Generate
Script.
- In the Generate Script wizard, the Deployment platform field is
pre-filled with a valid dbm file. Use the drop-down menu to select another
valid deployment platform.
- In the Query language group, specify SQL in the Query
language field.
- In the Query type group, specify Create a Select statement in the Query
type field.
- In the Script name field specify myfirstscript.sql as
the name, and click Next.
- On the Summary page, you can view the generated script, then click Finish. You now have an SQL script that is generated from the mapping
model. It is in the SQL Scripts folder. You can now
deploy or run your script.
- Expand the SQL Scripts folder.
- Right-click myfirstscript.sql and select Run SQL.
- Select an appropriate connection and click Finish.