We have had issues recently where items have been transferred to new bib. records and disappeared from Vega as a result and others where items were deleted and disappeared as expected, but then never reappeared once they were undeleted.

We would like to have a database sync process that can be run which compares the Vega database against the ILS to confirm that everything is in sync - basically a cross-system data integrity check or verification process between systems that would let us know if there was anything that was out of sync so we could investigate and correct it.

The reason this would be useful is because we are a library system where the item modifications are done by our libraries and the bib. modifications are done by the catalogers at the consortium level, so we have no way of knowing when an item change might trigger something like this to occur, and they might not always catch it when it does. In certain cases, the 'workaround' (which we've been told is just temporary until there's a permanent fix) is to edit the bib. record, which our libraries have no way of doing, so they would have to first realize what happened, then let us know so we could edit the bib. record.

Having a way to simply do regular integrity checks would help us catch any issues that might have been missed.