Best practice for data transfer from one table to another table in same servicenow instance

[ChandrimaM]

• How to transfer 12000 data from one table to another table in same servicenow instance with attachment?
• It's one time activity.
• Will we use import set or script?

[kiranit396]

Either way it can be done, with import set you would have more visibility 

Please follow the Best Practices, Make sure all the fields are mapped from source to destination and check if coalesce need to happen on any fields to make sure we are not inserting duplications.

Try to do a backup of Target data before loading the new data.

If you are performing via script check for failures in log.

[Mani A]

Since it is a one time activity., I would suggest to go with script and it will be easy also than TMaps

You can parse the attached data and loop it and insert into target table from parent table 

Let me know if you face any issue with script and paste it here ,will try to help you. 

Please mark the answer as correct so that it will be helpful for others. 

[Community Alums]

You can try to export the data from the original table as csv

Then reimport the excel data as a new data source and into a staging table.  Map the staging table with the new table as a transform map and then transform the loaded data

[ersureshbe]

Hi, I'm seeing there are 3 options

1. Integration hub spoke for servicenow to ServiceNow integration using import set table. It's a traditional method

2. Service bridge for servicenow to ServiceNow. If it's already exist use it else it's additional investment. Depends future integrations decide this option.

3. IDR instance data replication is another option for 2 instance integration

Other common traditional methods

1. Use platform capability using business rules, script includes using SOAP/REST.

2.Manual export and import access cities depends the complexity of instance it will vary.