Save and load configuration changes

Save All saves all of your changes for all of the tables that you have edited.

The Custom Module dropdown list contains overrides. Selecting one of these will include your set of custom overrides in addition to the server overrides and the CD_PROJECT overrides.

Clicking Update Database:

• Updates the tables

• Reloads the foreign keys

• Reloads the configuration overrides

• Updates the table definition to account for any changes to the tables (in case the tableColumnDesc was modified). For example, if you have enabled CD_STORE_HOURLY_DATETIMES, the columns will be added to the hourlyMeterReading table.

• Reloads the timezone tables, just in case a new timezone was added

• Reloads the stored procedures to account for any configuration changes

Check Database checks the database for any columns that should be removed due to changes in configuration.

For example, if you had enabled CD_STORE_HOURLY_DATETIMES and then disabled it, the columns added when you enabled this feature will be displayed. Then, you can decide if you want to either remove these columns, or re-enable the feature. This two-step process to delete columns helps you prevent accidental deletion of data.

Remove Unwanted Columns will remove the columns that are no longer required.

The results of each action will be displayed in the panel, as shown in the following image.