# Failed to use backup setting

**URL:** <https://community.cdata.com/t/failed-to-use-backup-setting/526>\
**Category:** CData Sync\
**Tags:** question, cdata-sync\
**Created:** [November 16, 2023, 4:10am UTC](https://community.cdata.com/t/failed-to-use-backup-setting/526 "2023-11-16T04:10:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahmanfp](https://avatars.discourse-cdn.com/v4/letter/r/2bfe46/32.png) [@Rahmanfp](https://community.cdata.com/u/Rahmanfp)\
**Post date:** [November 16, 2023, 4:10am UTC](https://community.cdata.com/t/failed-to-use-backup-setting/526/1 "2023-11-16T04:10:55Z")

</div>

Hi,

So I have a system with CDataSync&nbsp;to sync my data from SQL Server to Azure Synapse with below detail:

Old System:

CDataSync Version: 22.0.8342.0

CData AzureSynapse Provider Version:&nbsp;22.0.8326.0

New System:

CDataSync Version: 23.3.8704.0

CData AzureSynapse (23.0.8616.0)

I backup the old configuration and restore it to new configuration. However, it keeps getting an error like this

Error: The SQL Error Number is 103010, State is 1, Severity is 16, Error is ‘Parse error at line: 1, column: 126: Incorrect syntax near ‘.’.’, Server name is server1, Line number is 1. The Token Type is 170.

I found that the task is successful when I use this conditions:

1. I dont use a new scheme for the destination, but I checked the Drop Table/Truncate Table
2. I use a new scheme, but I unchecked the Drop Table/Truncate Table

Is there a new query or options that changed in the new version? What can I do to fix the error?

Thank you

---

<div class="post-metadata">

**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\
**Post date:** [December 14, 2023, 5:51am UTC](https://community.cdata.com/t/failed-to-use-backup-setting/526/2 "2023-12-14T05:51:52Z")

</div>

Hi @Rahmanfp

I see that this question has been sitting here for a while. From the looks of it, the error message you’ve encountered seems to indicate a syntax issue in the SQL query being executed by CData Sync when replicating data to Azure Synapse. Specifically, it mentions a parse error near a period (‘.’). This could be due to various reasons, such as an invalid column or table name, incorrect syntax, or an unsupported operation.

I’d suggest raising a Tech support case with our team at&nbsp;[CData - Support Form](https://www.cdata.com/support/submit.aspx).