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.
