Mismatch in Data Type Size

There is a possibility that Data Type Size of Salesforce field may not match with database field after replication.

Example:
Salesforce field with API name Bank_c and Data Type Text(255) is replicated as Bank_c (nvarchar(765),null). Here Data Type of replication is fine but not the Data Size. Data Type size in database is replicated as 765 characters instead of 255 characters.

Solution:

To resolve this issue, the below steps must be followed.

• Download the latest version (3.0.16.2b) of the ZIP or EXE file of the DBSync Cloud Replication tool from DBSync website using the URL http://mydbsync.com/integration/cloud-replication-for-salesforce (If the latest version of DBSync Cloud Replication is already installed, this step must be ignored).

• System Properties must be accessed from the installation folder DBSyncCReplSF3. The following path can be referred dbsync-repl > WEB-INF > db > conf > system.properties
• Open System.properties, at the end of the file identify the below mentioned commands as shown in the screen capture.

• Uncomment these commands as shown in the screen capture.

• Save System.Properties & restart the server before running the replication. After replication Data Type Size in Database will be same as Salesforce.