I assume when you say migrate from one app server to another, you mean from one Blue Prism environment to another. Multiple app servers can use the same queue if they are both pointing to the same database.
You could probably have a DBA extract the data from Database A and insert into Database B, but honestly that would make me nervous. I'd probably go about it with a workaround but what would be safer. I'd determine what logic is used to verify whether the item exists in the queue already. I assume it's purely checking for the Item Key. If it is, then you don't really need the entire queue items. All you need is to extract a list of Item Keys which you could do from inside a Blue Prism process or by querying the DB directly, then read from excel or whatever into a collection in Blue Prism and use the Add To Queue action to load all of those into the queue using the values as the Item Keys, and then just loop over the same collection to mark them all completed.
I would personally never encourage manipulation of the database unless the person has a very good understanding of the database schemas.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
