Archive User-defined tables
Comments
-
We have created a few user-defined SQL tables in Decisions that, over time, can grow pretty large. Similar to how Decisions logging works, are there any recommendations that will allow us to roll off data to a backup version of the main table once the main table gets to be “x” size?
-
Hello
We recommend you to archive the tables using the server itself. We can follow the recommended steps mention here: [url=https://www.sqlservercentral.com/articles/an-automated-process-to-archive-big-tables#:~:text=Create a new table with,Verify the result]https://www.sqlservercentral.com/articles/an-automated-process-to-archive-big-tables#:~:text=Create a new table with,Verify the result[/url].In this case, the only thing that we can do from the Decisions is transferring data from one DB to another. But, we would recommend doing this task also from the server itself.
Howdy, Stranger!
Categories
- 4.4K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 112 Rules
- 282 Administration
- 216 Portal
- 501 General Q & A
- 719 Forms
- 353 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 189 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 71 Repository
- 233 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions