DCR Option

DCR Option area

The users can see which DCR options are set for that instance.

Add DCR

• The users can set additional DCR options. In this case, the target is a table that has been added to the list of synchronized tables.

Search, delete abd edit

• The users can search by filtering the items the users want to search for.

• The users can remove or modify the DCR option.

DCR list

• The users can see a list of DCR options.

Item	Description
Source	Source Database's Schema.Table.
Option	The DCR Option that is set.
Column	DCR Option set information. SOURCE/TARGET If it is an option, it is meaningless, so nothing is described.
Default value	Default value set when MIN/MAX option is set.

---

DCR Option example

Add DCR Option

1. Select Sync Table

Among the tables specified as synchronization target tables, select the table for which the users want to set DCR Option based on the Source DB.

Caution

If the primary key does not exist in the table to set, the users cannot set it.

2. DCR Options

Set DCR Options.

MIN/MAX option selection

Item	Description
Source Column	Select a column of the Source table to set as DCR Option.
Type	The type of the column selected in Source Column.
DCR Option	MIN : Synchronize with the MIN value of the column value of the two rows where the conflict occurs. MAX : Synchronize with the MAX value of the column value of the two rows where the conflict occurs.
Default Value	The value to be treated as default if the column value is Null in the row where the conflict occurs.