We had set historic data retention period as 365 days.We do not want to increase the data retention period as it will affect the database server performance.
We are planning to move the data to another database server once post this 365 days(before the data gets deleted from the database after the historic data retention period)
can we achieve this? should we consider only historic tables(HN tables)
Please give your thoughts.