Skip to main content
SUBMITTED

Option to Truncate History Table

Related products:TimeXtender Data Integration
  • June 28, 2023
  • 1 reply
  • 24 views

sierd.zuiderveld
Contributor
Forum|alt.badge.img+1

Hi, 

 

During development it would be nice to have the option to fully truncate a History table, currently I believe the only option is to truncate directly on the SQL database?

1 reply

Forum|alt.badge.img
  • Contributor
  • October 21, 2024

To add to this, it might also be nice to have a process or setting in place to clean up a history table from time to time. Let’s say I only want to keep history up to the last 30 days or last full month. 

Doing a manual delete statement from time to time will take up tons of logging. Hence, I need to make a copy of the table, truncate the original table and then insert the data I want to keep back into the table. It would be good to have the application handle this process.