question Import/Export large amount of data on servicenow table. in Virtual Agent forum

Import/Export large amount of data on servicenow table.

SakshiBagal — Wed, 16 Jul 2025 08:28:44 GMT

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

Re: Import/Export large amount of data on servicenow table.

Pranesh072 — Wed, 16 Jul 2025 08:38:49 GMT

Take the export for entire table for backup.

Create your new phone field. Use fix script to copy the values from old field to new field. Then delete the previous field.

or you can try to modify old field type to mobile phone e164 if system allows it.

Re: Import/Export large amount of data on servicenow table.

Di Zhang — Wed, 16 Jul 2025 08:40:07 GMT

I am confused for “if I delete this existing field it can delete all mob no. ” what's you requirement?

Re: Import/Export large amount of data on servicenow table.

J Siva — Wed, 16 Jul 2025 08:41:37 GMT

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

Re: Import/Export large amount of data on servicenow table.

Ankur Bawiskar — Wed, 16 Jul 2025 09:05:50 GMT

@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.

Re: Import/Export large amount of data on servicenow table.

SakshiBagal — Thu, 17 Jul 2025 07:26:22 GMT

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