We have about 80 sites in several site collections. The items were imported into each of these "archive" sites from a main site and the SharePoint "export" functionality keeps the ID from the original site. So I have lists where there are huge gaps in the IDs and/or the IDs don't even start until they get into the hundred thousands. So if my list only has 261 items but the IDs are in the hundred thousands Content Matrix is creating 100,000 "temporary" items to "use" the non-existing IDs. This is taking a ton of time as you can imagine because it literally creating half a million items in each site since there are half a million items all together.
For several lists we have opted not to preserve IDs as there will only be new items and not any modified items. But for one list we will have many modifications and new items so a delta will be necessary. Is there anyway to do a delta without preserving the IDs? For instance can I supply Content Matrix with another Unique field and have it use that field for the incremental?
Or is there another way to preserve the ID without the tool creating the "temporary" records.