Analyze Your Database and Improve Data Quality › Examine the Consistency and Integrity of Any Database (New or Production)

Previous Topic: Validate the Structure of Your Databases

Next Topic: Analyze the Model

Examine the Consistency and Integrity of Any Database (New or Production)

To examine the consistency and integrity of any database (new database, production database), you need to use CA ERwin Data Modeler to reverse-engineer the database and save it as a CA ERwin Data Modeler model (.erwin file).

To examine the consistency and integrity of any database

  1. Click File, New on the main menu.

    Data Modeler Validator File Menu New selection

    The Select Project Type dialog opens.

  2. Select CA ERwin DM and click OK.

    select project type dialog

    The Open a Project dialog opens.

  3. Select the CA ERwin DM model that you want to open and click Open.

    select erwin model to open

    You are connected to CA ERwin Data Modeler and the Select Tables dialog opens.

  4. Select the tables you want to open and click OK.

    The model opens.