Online Documentation for Data Comparer for MySQL
Configuration file format
The configuration (template) file used by Data Comparer for MySQL is divided into several sections, each corresponding to a particular group of settings specified at different steps of the GUI application wizard.
[#General#]
This section stores general information about the utility:
|
Parameter |
Description |
|
Product |
internal product name |
|
Version |
major version |
[#SourceDB#]
This section stores connection parameters for the source database. The parameters correspond to the values entered at Step 1 of the Wizard application and are obligatory.
|
Parameter |
Description |
|
Host |
host where the source database resides (if Remote = 1) |
|
Port |
port on which MySQL is listening |
|
Remote |
0 = local connection 1 = remote connection |
|
DBName |
source database name |
|
Login |
MySQL login |
|
Password |
password to identify the login (encrypted) |
|
Charset |
client character set specified for the connection |
|
FontCharset |
the parameter is not used by Data Comparer for MySQL |
|
TunnelType |
indicates the tunneling type being used: SSH, HTTP, or none (TunnelType = ttNotUse) |
|
SSHHostName |
name of the host where SSH server is running |
|
SSHPort |
port on which SSH server is activated |
|
SSHUserName |
user on the machine where SSH server is running |
|
SSHPassword |
password to identify SSH server user (encrypted) |
|
SSHKeyFile |
path to the Private Key used for the SSH connection (if SSHUseKeyFile = True) |
|
SSHUseKeyFile |
True = SSH Private Key is used False = SSH Private Key is not used |
|
HTTPUrl |
URL to the emsproxy.php script file uploaded to your web-server (for HTTP tunneling) |
[#TargetDB#]
This section stores connection parameters for the target database. The parameters correspond to the values entered at Step 1 of the Wizard application and are obligatory. The set of parameters is the same as for the source database ([#SourceDB#]).
[#Options#]
This section stores comparison options. The parameters correspond to the values specified at Step 2 and Step 3 of the Wizard application.
|
Parameter |
Description |
|
Blobs |
0 = BLOB fields are not specified for comparison 1 = BLOB fields are specified for comparison |
|
IgnoreCase |
0 = case is considered when comparing strings 1 = case is ignored when comparing strings |
|
FillIdentical |
0 = identical records are not displayed at Step 3 of the wizard 1 = identical records are displayed at Step 3 of the wizard |
|
ViewRecordsCount |
number of records displayed on one page at Step 3 of the wizard |
|
ThreadCount |
number of comparison threads |
|
SavePassword |
0 = Password is not saved in template file 1 = Password is saved in template file |
|
PasswordEncripted |
0 = Password is not encrypted in template file 1 = Password is encrypted in template file |
|
TrimCharFields |
0 = CHAR fields are trimmed on synchronization 1 = CHAR fields are not trimmed on synchronization |
|
CompareOnServerSide |
0 = comparison is performed on the client 1 = comparison is performed on the server |
[#SyncOptions#]
This section stores synchronization options. The parameters correspond to the values specified at Step 4 and Step 7 of the Wizard application.
|
Parameter |
Description |
|
TargetToSource |
0 = synchronization from source to target 1 = synchronization from target to source |
|
TablePostfix |
postfix added to the synchronization table name (if SyncInNewTable = 1), by default _sync |
|
SaveScript |
0 = synchronization script is saved to an external file upon saving template 1 = synchronization script is not saved |
|
DisableTriggers |
the parameter is not used by Data Comparer for MySQL |
|
ScriptFileName |
path to the file into which the synchronization script is saved (if SaveScript = 0) |
|
InsertMissRecs |
0 = missing records are ignored during synchronization 1 = missing records are inserted during synchronization |
|
DeleteAddRecs |
0 = additional records are ignored during synchronization 1 = additional records are deleted during synchronization |
|
UpdateDiffRecs |
0 = different records are ignored during synchronization 1 = different records are updated during synchronization |
|
SyncInNewTable |
0 = synchronization is performed in the source (if TargetToSource = 1) or in the target (if TargetToSource = 0) table 1 = a new table is created and the synchronized data are inserted into the table |
|
CreateComputed |
the parameter is not used by Data Comparer for MySQL |
|
LoadToScriptEditor |
0 = synchronization script is not loaded to Script Editor 1 = synchronization script is loaded to Script Editor and displayed at Step 5 of the wizard |
|
AbortExecuteOnError |
0 = synchronization process is not stopped if an error occurs 1 = synchronization process is stopped upon any execution error |
|
DetailErrors |
0 = detailed error log is not displayed 1 = detailed error log is displayed on the screen at Step 7 of the wizard |
|
ExecuteScript |
0 = synchronization script is not executed automatically 1 = synchronization script is executed automatically by the console version after template creation |
|
DropIndexes |
0 = table indexes are not considered 1 = table indexes are dropped and then recreated in the synchronization script |
|
CommitAlter |
number of committed records in the synchronization script |
|
Autofill |
0 = tables correspondence set at Step 2, will not be set automatically 1 = tables correspondence will be set automatically |
[#Comment#]
This section stores the template file comment as specified optionally in the Save template options dialog:
|
Parameter |
Description |
|
Line<N> |
comment text |
where N stands for the comment line identifier
Example:
Line0=Data Comparer for MySQL
Line1=Template file
Line2=Data synchronization #1
[#SrcAfterScript#]
This section stores the text of the script executed for the source database after data synchronization, as specified at Step 6 of the Wizard application.
|
Parameter |
Description |
|
Item_Count |
number of lines |
|
Line<N> |
script text |
where N stands for the script line identifier
Example:
Item_Count=2
Line0=/*AFTER synchronization*/
Line1=/*script to be executed for the source database*/
[#TrgAfterScript#]
This section stores the text of the script executed for the target database after data synchronization, as specified at Step 6 of the Wizard application.
|
Parameter |
Description |
|
Item_Count |
number of lines |
|
Line<N> |
script text |
where N stands for the script line identifier
Example:
Item_Count=2
Line0=/*AFTER synchronization*/
Line1=/*script to be executed for the target database*/
[#SrcBeforeScript#]
This section stores the text of the script executed for the source database before data synchronization, as specified at Step 6 of the Wizard application.
|
Parameter |
Description |
|
Item_Count |
number of lines |
|
Line<N> |
script text |
where N stands for the script line identifier
Example:
Item_Count=2
Line0=/*BEFORE synchronization*/
Line1=/*script to be executed for the source database*/
[#TrgBeforeScript#]
This section stores the text of the script executed for the target database before data synchronization, as specified at Step 6 of the Wizard application.
|
Parameter |
Description |
|
Item_Count |
number of lines |
|
Line<N> |
script text |
where N stands for the script line identifier
Example:
Item_Count=2
Line0=/*BEFORE synchronization*/
Line1=/*script to be executed for the target database*/
[#SpecOptions#]
This section stores some server-specific options.
|
Parameter |
Description |
|
LockTables |
0 = non-transactional tables are not considered 1 = non-transactional tables are locked before comparison |
[SrcSchemas]
This section is not used by Data Comparer for MySQL.
[TrgSchemas]
This section is not used by Data Comparer for MySQL.
[Table<N>]
Sections of this type contain table/field correspondences (N stands for the correspondence identifier), as specified at Step 2 of the Wizard application.
|
Parameter |
Description |
|
#SourceTable# |
source table name |
|
#TargetTable# |
target table name |
|
Synchronize |
0 = tables will not be synchronized 1 = tables #SourceTable# and #TargetTable# are specified for synchronization |
|
<field_name> |
corresponding target table field |
|
<field_name>_CompareKey |
0 = the field is not used as key column for data comparison 1 = the field is used as key column for data comparison |
Example:
[Table0]
#SourceTable#=EMPLOYEE
#TargetTable#=EMPLOYEE_UPD
Synchronize=1
EMP_ID=EMP_NO
EMP_ID_CompareKey=1
FIRST_NAME=FIRST_NAME
FIRST_NAME_CompareKey=0
LAST_NAME=LAST_NAME
LAST_NAME_CompareKey=0
