Import/Export large amount of data on servicenow table.

SakshiBagal · ‎07-16-2025

I have a requirement create new field(mobile phone E164) and remove mobile phone field but if I delete this existing field it can delete all mob no. So, I want to take back up of 1600000 record in servicenow and again import it in sys_user table. What is best method which can take less time in restoring data and won't affect on integrations

J Siva · ‎07-16-2025

Hi @SakshiBagal
Instead of deleting the field, just deactivate it.
Use a fix script to copy the values from the existing Mobile field to the new Mobile Phone (E.164) field, and then deactivate the original Mobile field.

Regards
Siva

View solution in original post

Ankur Bawiskar · ‎07-16-2025

@SakshiBagal

I won't recommend deleting the field, deactivate that field.

Simply create new field and load data into this new field.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

PrashantT · ‎07-17-2025

Hi @SakshiBagal ,

As per your requirement if you want the field "mobile phone E164" on user table you can just the rename the existing "mobile phone" field with "mobile phone E164". I think that is better solution without any customization.

Here the path to do so-
Step 1: - Right click on the field to open the dictionary of that field.

Step 2:- In the related list of field dictionary, double click to rename the name of the field as "mobile phone E164".

Expected Result:

Please accept my solution and give it a thumbs up if it's helpful for you.
Regards,
Prashant

View solution in original post

SakshiBagal · ‎07-17-2025

How to take backup of 16000000 record? as it allows only 10000 in one go