Comparing Data Sources with Database Definition Files

Comparing and updating your data source so that it matches the database definition allows it to function correctly with Trapeze software.

A *.dbd file or *.db-schema file must be open in DBEdit.
When new tables or fields are created or existing tables are modified in the database schema, the database using them must be updated to include these new options.

Never remove tables or fields from *.dbd or *.db-schema files.

  1. Do one of the following:
    • Click Datasource > Compare with Dbd.
    • Click the Compare button:
      Question mark and equals sign.
    The Compare Differences with Dbd dialog box appears.
  2. Select the appropriate check boxes with which you want the system to compare the databases.
  3. Click Compare.
    The status bar at the bottom of the dialog box indicates that the system is processing the data. (To stop the process, click the red X button beside the status bar.)

    A list of tables that have differences appears in the top left frame.

  4. (If you have existing data) To synchronize the data with existing data, select the tables that you know are used in the application on which you are working and click Apply to Datasource.
  5. (If you have an empty database) In the TableDifferences box, select all of the TableDifferences and then click Apply to Datasource.

    Create the empty database first in either Oracle or Microsoft SQL. For more information on this, refer to the documentation of these relational database management systems.

  6. (If Applicable) Determine how best to handle any remaining data differences.
    Contact your Trapeze representative for more information.
  7. Click Close.