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.
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.

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.
Last updated