8. Reconcile a CIMPLICITY table with a Logging Database

The Reconcile table dialog box opens.

A	Table reconcile status color code
B	Reconcile buttons

A	Table Reconcile Status Color Code

The icon colors display the differences between the CIMPLICITY table (Database Logger configuration) and the logging database as follows.

	Field in the CIMPLICITY	Field in the
Icon	Database Logger	Logging Database	Comment
	Yes	Yes
	Yes	Yes	Types don't match.
	No	Yes	Unused
	Yes	No	Uncreated
	Removed	Removed

B	Reconcile Buttons

Reconcile buttons are available to perform the following actions.

• Refresh the view.

Refresh

Click Refresh.

• Create uncreated fields that are in the CIMPLICITY table but not in the logging database.

	Select uncreated
	Create

1. Select the fields that display the icon.

Tip: Do one of the following.

• Press the Shift or Ctrl key to select multiple fields
• Click Select Uncreated to select all the uncreated fields in the table.

1. Click Create.

The fields are created in the logging database. The fields' icons change to: ??

• Remove unused fields that are in not in the Database Logger, but are in the logging database.

	Select unused
	Remove

For Microsoft Access (As-Is product)

1. Select the fields that display the icon.

Tip: Press the Shift or Ctrl key to select multiple fields, or click SelectUnused to select all the unused fields in the table.

1. Click Remove.

SQL Server and Oracle

SQL Server and Oracle do not directly support dropping columns in a database table.

1. Copy the table to a temporary table.
2. Drop the table from the database.
3. Recreate the table with the fields you wish to use.
4. Copy the data from the temporary table to the new table.
5. Delete the temporary table.
6. Consult your SQL Server or Oracle documentation for details on how to do this.