# How to setup Incremental Replication

**URL:** <https://community.cdata.com/t/how-to-setup-incremental-replication/1106>\
**Category:** CData Sync\
**Tags:** data-replication, incremental, question\
**Created:** [June 11, 2025, 4:22am UTC](https://community.cdata.com/t/how-to-setup-incremental-replication/1106 "2025-06-11T04:22:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BI-Mod](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@BI-Mod](https://community.cdata.com/u/BI-Mod)\
**Post date:** [June 11, 2025, 4:22am UTC](https://community.cdata.com/t/how-to-setup-incremental-replication/1106/1 "2025-06-11T04:22:35Z")

</div>

Hi,

I have 3 years worth of data. All the data stay the same but the latest 3 months are dynamic.

I need to replace the old data with the latest data. But if I do “Drop Table”, it drops all the data and bring all 3 years worth of data and sometimes the system dont seem to be able to handle it.

I would like to keep everything and just have the last 3 months tables dropped and replaced. I dont want the system to have to bring ALL data from the past 3 years. I just need the last 3 months dropped and replaced.

What setup should I do?

---

<div class="post-metadata">

**Author:** ![Prateek\_Jain](https://avatars.discourse-cdn.com/v4/letter/p/85e7bf/32.png) [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\
**Post date:** [June 12, 2025, 12:27pm UTC](https://community.cdata.com/t/how-to-setup-incremental-replication/1106/2 "2025-06-12T12:27:33Z")

</div>

It is possible if:  
1. We create a destination Table A having all the data upto last 3 months(for example: March 2025)&nbsp;by setting the ReplicationEndDate in the advanced job options. Please refer the following documentation:&nbsp;[CData Sync - Advanced Job Options | 25.3.9396](https://cdn.cdata.com/help/ASM/sync/Advanced-Job-Options.html#additional-options:~:text=avoid%20replication%20errors.-,ReplicateEndDate,-None)  
2. Create another task having destination Table B where ReplicationStartDate set to 3 months back(for example: April 2025)&nbsp;and perform the full load every time.  
3. Create a Transformation to merge Table A and Table B in destination and it should be scheduled after performing the 2nd Step.

I hope this will work in your use-case. Let us know if you have further questions or else you can drop a mail on [support@cdata.com](mailto:support@cdata.com)