We need some suggestions regarding data synchronization between our UAT and Prod instances in ServiceNow (sys_user)table.
Currently, we have around 50,000 users with mismatched data between the UAT and Prod instances. We run a weekly scheduled job to import users into the UAT instance. However, since some users were already created earlier in UAT, the user data between Prod and UAT is not fully aligned.
Additionally, we are unable to delete the existing UAT users and rerun the scheduled job, as the job does not support a full data load due to the large volume of records. The same limitation applies when attempting to use XML export/import.
Our goal is to synchronize the user records in UAT with those in Prod.
Could you please suggest the best approach to handle this situation?
also I would like to know:
Is it possible to clone only the sys_user table from Prod to UAT?
If yes, could you please guide us on the process for performing a partial clone? I dont want full clone
Alternatively, if there are any other recommended methods to effectively synchronize the user records, we would appreciate your suggestions.
Thank you in advance for your guidance.
