We started using a single NintexWorkflowHistoryList when we started out. We had a single workflow so ...
Well now we have a dozen workflows all writing to this list and it had grown to over 250,000 rows.
What I would like to do is to create a new list for each workflow and migrate existing entries in the old list to the new list.
Eventually we will have an archive system in place that will move this data to a repository so having a list per workflow will provide for different archive requirements and make for more straightforward and intuitive setup going forward.
Are there any issue that can occur when moving existing history items to a new history list? Will the current items still be able to look up the history?