Previous Topic: Schema Customization

Next Topic: Display the Schema Designer

Customizing › Schema Customization › How to Modify the Schema

How to Modify the Schema

To modify the CA SDM schema, complete the following steps:

  1. Make your changes with the Schema Designer in WSP. Changes can include modifying existing tables and columns and defining new ones.
  2. Put your changes into test mode. Changes in test mode are defined to the Object Engine associated with WSP, but are not defined to the physical database. Web Screen Painter users can access the modified schema, but typical CA SDM users are not exposed to them.
  3. Update or create web forms using the modified schema. You can examine data in your web forms, and even create or update records in site-defined tables without affecting the CA SDM database. All updates affect only the Object Engine associated with Web Screen Painter.
  4. Repeat Steps 1 through 3 until you are satisfied with your schema changes and with the web forms that use them.
  5. Publish your schema changes. Publishing requires shutting down CA SDM.