# 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: <a href="#mismatchindatatypesize-solution" id="mismatchindatatypesize-solution"></a>

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).
* System Properties must be accessed from the installation folder *DBSyncCReplSF3. The following path can be referred dbsync-repl* > *WEB-INF* > db > conf > *system.properties*![](https://help.mydbsync.com/docs/download/attachments/31983573/worddavb3f78a950423b1273558313a398299a1.png?version=1\&modificationDate=1546871074000\&api=v2)
* 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](http://force.id/)=nchar(18)\
force.date=datetime2(7)\
force.datetime=datetime2(7)

![](https://help.mydbsync.com/docs/download/attachments/31983573/worddav7a5ad44f10b59e96e8ce053d92ac00d7.png?version=1\&modificationDate=1546871074000\&api=v2)

* Uncomment these commands as shown in the screen capture.

![](https://help.mydbsync.com/docs/download/attachments/31983573/worddav516b5086f90bdaf9e94f2bf53fff7fd8.png?version=1\&modificationDate=1546871074000\&api=v2)

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

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/troubleshooting/mismatch-in-datasize.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.