Online Documentation for Data Comparer for SQL Server
Configuration file format
The configuration (template) file used by Data Comparer for SQL Server 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/instance where the source database resides |
|
Remote |
0 = local connection 1 = remote connection |
|
DBName |
source database name |
|
Login |
SQL Server login (if NTAuth = 0) |
|
Password |
password to identify SQL Server login (encrypted) |
|
NTAuth |
0 = SQL Server authentication 1 = Windows authentication |
|
ConnTimeout |
connection timeout |
|
TunnelType |
the parameter is not used by Data Comparer for SQL Server |
[#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 |
0 = table triggers are not considered 1 = table triggers are disabled during synchronization (if SyncInNewTable = 0) |
|
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 |
0 = computed and read-only fields are excluded from the synchronization process 1 = computed and read-only fields are included into the synchronization process |
|
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 SQL Server
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. The parameters correspond to the values specified at Step 2 of the Wizard application.
|
Parameter |
Description |
|
FastComparison |
0 = fast comparison is not used for SQL Server tables 1 = fast comparison is used for SQL Server tables |
[SrcSchemas]
This section stores the list of source database schemas specified for comparison.
|
Parameter |
Description |
|
Item_Count |
number of schemas |
|
Line<N> |
schema name |
where N stands for the schema item identifier in the list
Example:
Item_Count=1
Line0=DEMO
[TrgSchemas]
This section stores the list of target database schemas specified for comparison.
|
Parameter |
Description |
|
Item_Count |
number of schemas |
|
Line<N> |
schema name |
where N stands for the schema item identifier in the list
Example:
Item_Count=2
Line0=TEST
Line1=PRODUCTION
[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 |
|
#SourceOwner# |
schema/owner of the source table (#SourceTable#) |
|
#TargetOwner# |
schema/owner of the target table (#TargetTable#) |
|
<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
#SourceOwner#=DEMO
#TargetOwner#=PRODUCTION
EMP_ID=EMP_NO
EMP_ID_CompareKey=1
FIRST_NAME=FIRST_NAME
FIRST_NAME_CompareKey=0
LAST_NAME=LAST_NAME
LAST_NAME_CompareKey=0
