Import/Export large amount of data on servicenow table.

[SakshiBagal]

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 · Accepted solution]

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

[Ankur Bawiskar · Accepted solution]

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

[Pranesh072]

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.

[Di Zhang]

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

[J Siva · Accepted solution]

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

[Ankur Bawiskar · Accepted solution]

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