Introduction
The SICS Configuration Manager module enables the user to compare various SICS system settings / base data between two SICS databases (schemas). The differen...
SICS Configuration Manager
Click on any of the topics below to see more information.
Overview
In the following, ‘Configuration Manager’ will be abbreviated as ‘CM’. The CM allows to select the target SICS schema (provided it is defined in the \runt...
Initial Setup
The SICS Configuration Manager module is protected by a module key. Start SICS System Administration Utility, open System Parameter Maintenance, switch to th...
Starting the Configuration Manager
Start the SICS System Administration Utility. Log in with a source user and select the source environment. The source user (or the associated 2nd level user ...
Comparing Data
Select the desired data provider from the drop down list. Some data providers handle a large number of database rows and there may be a noticeable delay as t...
Generating SQL
Click the ‘Show SQL…’ button to generate SQL for the selected items. The result will be similar to the following example INSERT INTO REFERENCE_DATA (SUBCL...
Data Providers
A number of data providers are available for selection, but every kind of ‘configurable’ data is not covered. Additional data providers may be added to the f...
Noteworthy
The two data values "" (empty string) and null (data missing / not present) are considered different, not equal. The source and target syst...