DDL
DDL area
The users can set DDL synchronization options.
ADD DDL
The users can set DDL synchronization options for synchronization tables.
Search and delete/edit
The users can search by filtering the items the users want to search for.
The users can remove and edit DDL options.
Exclude Set
A list of options to exclude from synchronization during DDL.
Include Set
A list of options to include in synchronization during DDL.
By default, ALTER TABLE, TRUNCATE TABLE DDL synchronization is performed for the synchronization table (DEFAULT).
Rule Sequence
The sequence number for the rule, and the DDL rule is applied in that order.
Range
The Range to which the DDL rule is applied.
ALL: Applies to all schemas and tables in the Source DB regardless of synchronization.
DEFAULT: Applies to all tables registered in the synchronization table.
CUSTOM: This option is used to specify a table directly.
DDL Operation
DDL commands such as ALTER, CREATE, and DROP
DDL Object
The type of object targeted by DDL commands such as TABLE, VIEW, and INDEX.
DDL example
Rule Sequence
Exclude Set and Include Set appear to be separate options, but in the ProSync engine they are written as a single string and are applied in the order they are written.
Therefore, the Rule Sequence entry exists to distinguish the order in which the options are applied.
In the above example, the ALL Range and DEFAULT Range of the Exclude Set are checked for ALTER TABLE.
In this case, the Rule Sequence has priority because the ALTER TABLE in the DEFAULT range of the Include set is lower, and the ALTER TABLE in the ALL range of the Exclude Set is not synchronized.
Add DDL
The users can set additional DDL options.
Set
Include or Exclude settings.
Range
Select the range of DDL occurrence.
Type
Select the type of DDL command and the target Object of the command.
The users can add multiple Types by clicking the Add button next to it.
In this case, the Rule Sequence has the same value.
Last updated