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 if using two level login) must have SELECT, UPDATE, DELETE, INSERT rights on all SICS tables in the source schema.

In the case of Oracle, the source user must also have SELECT rights on various RDBMS system tables / views containing meta data (SYS.ALL_TAB_COLUMNS and SYS.ALL_COL_COMMENTS).

In the case of SQL Server, the source user must be defined in SQL Server as having the source database/schema as the default database/schema.

Once logged in to the SICS System Administration Utility, expand the System Administration folder and double-click the ‘Configuration Manager’ entry.

Click the ‘Add Target…’ button in order to enter details for the target schema.

Enter Data Source, [target] User and Password. The Schema field is optional, if not entered it will default to the User. Note that there is no support for two level login for the target user, so the target user must have SELECT, UPDATE, DELETE, INSERT rights on all SICS tables in the target schema.