Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Data migration in ServiceNow - switch off auto number field

snehapatel
Tera Contributor

an hour ago

Hi,

 

I have built a custom application wherein a custom table is created by extending the task table.  Now I have to migrate the data into this new custom able from a legacy application (non-ServiceNow). The legacy system has a ID field which has a different format than that of what is stored in the custom table (mapped to an auto number field). When migrating the data what should be the right approach:

1) Should I introduce a separate field to store the legacy system ID and the auto number field should work as it is.

2) Should I map the auto-number field to legacy system ID field. If that is the case, then how to switch off auto numbering when migrating he records.

 

Thanks,

Sneha

 

0 Helpfuls
  • 68 Views
1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

40m ago

@snehapatel There is the third option, you can map the legacy system ID field to an OOTB correlation_id field which is available out of the box on the task table. You can map your legacy system ID to this field and refer to it later. 

 

Hope this helps.

0 Helpfuls