Incorrect Syntax Near Column Name

Issue Description:

Salesforce and Microsoft SQL Server Column size mismatch Issue : A column of a table in Microsoft SQL server has an column size lesser than that of column that is mapped with that of configured Salesforce Object so while Replicating the data, The system throws the error of below format.

SEVERE [Thread-CONSUMER:Opportunity] com.dbsync.salesforce.integration.DBAdapter.commitSynch BATCHED INSERT FAILED:Incorrect syntax near 'r_of_Approved_Transact'.

Solution:

The issue is because the Microsoft SQL Server limits any column name of a table to be more than fifty characters, To overcome this issue you might have to Rename the column name with no more than fifty characters from the replication tool itself.

Follow, the article from the link Rename Table or Column to renaming a column from replication UI