Mismatch in Datasize

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 (6.0) 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).

  • Open System.properties, at the end of the file identify the below mentioned commands as shown in the screen capture.

data structure matchup to DBAMP for multibyte use nchar(8), for single byte use char(8) force.id=nchar(18) force.date=datetime2(7) force.datetime=datetime2(7)

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