Sys ID duplication chances while migrating records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2024 01:40 AM
I'm importing millions of record from a table from one instance to other in a custom table.
The same sysID of source instance are getting copied over to the destination instance.
My Question is: is this a good practice, will this potentially lead to a sysID mismatch, I mean, can a sysid from source instance be similar to any sysid from destination instance of any record even of any other table, since the sysID is unique to one instance, it may not necessarily be unique to other instances as well.
I'm concerned because I'm also importing the journal fields, which require to match the sysid's of the record of the imported table to the element ID of journal table in order to link them correctly.
If this is right, I'll let system generate a sysID after importing on destination instance and store the sysid of source instance in a sperate field.
Thanks a lot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
Hi Mehant,
Are you importing those records via XML Import or by using Import sets ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
Hi @Mehant Kumar1 ,
Refer below link
If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand
