Migrate SharePoint list using ShareGate (Item ID are different in Source and destination those id due to item id are deleted)

Question

while migrating on destination , item id are incrementally assigned automatically...if any records are deleted form source then that id also have been assigned in desitnaion..so that item id are different in source and destination .

Also we are using sharegate as list stp is unable to create as its size is 2 gb due to attachments in the list

Answer 1

This is correct behavior as the underlying table is auto-incrementing. The only way to "fix" this is to pre-allocate IDs, but if you have gaps in IDs (i.e. 3, 6, 7, 9), your gaps will be filled in during the migration.

There is nothing you can do to prevent this.

Answer 2

Hi @Shiv Sharma ,

By default, List item IDs will not be preserved. For more details, please refer to:

• https://support-desktop.sharegate.com/hc/en-us/articles/115000643268-List-item-IDs

As for the file size limitation, you can take a reference of below articles:

• https://support-desktop.sharegate.com/hc/en-us/articles/115000600647-Unable-to-copy-because-the-size-exceeds-the-maximum-size-allowed-by-SharePoint
• https://support-desktop.sharegate.com/hc/en-us/articles/115000644148-Is-there-a-file-size-limitation-

Best Regards,
Baker Kong

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

IIRC item id's are preserved during an export-spweb/import-spweb.