Best way to consolidate "pending" items from database backups?

Hello

In my setup I have 2 databases, and across them almost 2000 items with the status “pending”. I thought that, sometime, somewhere, those got lost across syncing or in a different way.

I have 2 old database backups (one from 2021, one from 2024), and these have most if not all of the items “pending” in my current database. I’m wondering about the best way to update these items in my current database by copying those items from any of the two backups.

Ideally, I don’t want to do this manually, and I’m wondering if there is a good way or automation that could help with that?

I’ve started using DT 4, but the backups were based on the then-current versions (all of them Pro).

Any help / suggestions on how best to proceed would be great!!

Thanks
Peter

Did you already try to download the pending items (see File > Download Pending Items)?

I tried but got the message “File not yet available”. I think I still have the metadata in my database but the original items got corrupted or missing. As many / most of them should be in either of the backup databases, I want to get them from there.

Of course in general I want to keep the structure of my current database. Probably I could just copy all of the items from the backup over and then delete older duplicates, but I’m not sure if that would mess with the structure…

One more question - if I open any of the backed up databases, I get a warning that both databases have the same UUID. Will that cause any confusion to DT if I have them both open in the program at the same time?

Syncing will be suspended for the databases but DEVONthink can manage them.

For any future reference, there’s another thread with a JavaScript that solves the problem: Duplicating a record between databases?