- Tour of Data Sync
- Data Sources
- Installing Data Sync
- Install Encryption Key
- Connecting to a Source
- Connecting to a Target
- Connection Properties
- Schema Mapping
- Compare
- Synchronise
- Incremental Sync
- Create a Connection Library
- Using the Connection Library
- Edit the Connection Library
- Lookups
- Calculated Columns
- Filters
- Dynamic Columns
- Project Automation
- Project Properties
Project Properties
The below tutorial will cover what project properties are and how these can be changed to suit your needs.
Project properties allow you to manage certain settings on a project by project basis. To access these got to File > Properties
Assemblies
Allows you define extra external .NET Assemblies to load into the current App Domain on Project Load.
Connection
OverrideSSLCheck
Used to disable SSL Certificate checking and if True will accept all certificates.
Duplicates
DuplicateKeyMode
Sets how duplicate keys should be handled. Either IncludeFirst where Data Sync will retain the first duplicate it comes across or RemoveAll where Data Sync will remove all duplicate keys from the sync.
Properties
Properties are a Collection of Key/Value pairs that you can add to your Project. These are useful in Dynamic Columns and Project Automation where you want to store configuration values that can be changed easily by the user.
Synchronisation Service
SyncFailOnError
If True (default) causes the Sync to fail on the first error, otherwise the Sync continues.
SyncOption
Sets the Sync Mode of operation to one of the supported sync modes.
SyncAtoB
Sync from DataSource (A) to DataSource (B) (default).
SyncAtoBIncremental
Sync from DataSource (A) to DataSource (B) in Incremental Mode.
SyncBtoA
Sync from DataSource (B) to DataSource (A).
SyncBtoAIncremental
Sync from DataSource (B) to DataSource (A) in Incremental Mode.
SyncAandB
2-Way Sync via Snapshot SQL Compact DB (deprecated).
Text Compare
EmptyStringAndNullAreEqual
If True (default) Empty Strings and NULL values are the same.
IgnoreCase
If True (default) causes the Compare Engine to ignore case differences in string data.
IgnoreInvalidXmlChars
If True (default) causes the Compare Engine to strip out invalid XML characters before comparing string data.
Uses the following RegEx expression to remove invalid XML Characters.
[^\x09\x0A\x0D\x20-\xD7FF\xE000-\xFFFD\x10000-x10FFFF]
IgnoreWhiteSpace
If True (default) causes the Compare Engine to ignore any white-space differences in string data.