copying work item from W1 with 3.5M+ of records to W2 - Data Volume Issue
We have a functionality like copying work item W1 to W2 including the data of W1.
When we are copying the work item whole data (this data will going to fetch from the external DB) which was exist in w1 (this data saved in external DB ) has around 3.5M+ in one screen. because of this volume of data copying work item takes very large amount of time (look like process is In-Progress after 8hours also).
Please suggest the better way to copy the work items of w1 to w2 with data from external DB to complete the task in minimum time interval.
Thank you.