< Previous | Next >

Generating and deploying an SQL script based on the mapping model

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:

  1. Right-click myfirstmapping.msl mapping model and select Generate Script.
  2. 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.
  3. In the Query language group, specify SQL in the Query language field.
  4. In the Query type group, specify Create a Select statement in the Query type field.
  5. In the Script name field specify myfirstscript.sql as the name, and click Next.
  6. 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.
  7. Expand the SQL Scripts folder.
  8. Right-click myfirstscript.sql and select Run SQL.
  9. Select an appropriate connection and click Finish.
< Previous | Next >

Feedback