CA ERwin Data Modeler r8 New Feature Guided Tours › New Database Support › Schema Validation

Schema Validation

Use the following steps to become familiar with schema validation.

  1. Open one of your DB2 v9.x, SQL Server 2008, or Teradata v13 models containing newly-supported physical properties and indexes (modified in previous steps).
  2. Click Forward Engineer, Schema on the Actions menu or click the Forward Engineer Schema Generation icon Forward Engineer Schema Generation on the toolbar.
  3. Click the Preview button and review the SQL generated for errors or other issues.
  4. Click Generate (catalog or script), and note any issues.
  5. Click Close and then click OK to exit the Forward Engineer Schema Generation dialog.
  6. Repeat steps 1 through 5 as needed.