Creation Options
On a database
It is possible to configure synchronization for each database in order to modify:
• Its creation options
• Processing of repository integrity (keys OnDelete or OnUpdate as a function of the possibilities offered by the DBMS target)
This configuration also concerns processing of the Not Null columns and the automatic creation of indexes on primary keys.
To configure the creation options for the database:
1. Right-click the database and select Properties.
The properties window appears.
2. Click the drop-down list then Options > Synchronization.
The corresponding options appear.
You can specify the following parameters:
• Columns Not Null activates/deactivates the WITH DEFAULT option for Not Null columns.
• OnDelete: key deletion default strategy. Possible values are:
• Restrict: deletion is refused.
• Cascade: deletion of a column is reflected in dependent tables.
• Set Null: indicates "Null".
• Set Default: gives the default value if this is specified. If no default value is specified, nothing occurs ("No action").
• No Action: nothing occurs.
• OnUpdate: key update default strategy.
Parameters whose names begin with Names of indicate rules applied in name generation (see Configuring Name Generation).
On the DBMS
The default values for database synchronization and generation parameters are accessible in the properties dialog box of the DBMS used.
To display DBMS synchronization parameters:
1. In the HOPEX toolbar, click the Utilities navigation window.
2. Right-click the target DBMS name and open its Properties dialog box.
3. Click the drop-down list then Options > Synchronization.
By default, the parameters specified at the DBMS levels are valid for all new databases. When you modify synchronization parameters on a database, this database no longer takes account of DBMS parameters.
For more information on synchronization configuration, see also Running Synchronization (Logical > Physical).