How to move attachments from 1 ServiceNow instance to another ServiceNow instance?

Suggy
Giga Sage

We have two ServiceNow instances 'A' and 'B'.

 

We need to migrate all the Contracts from A to B (there are around 5000 Contracts). As both the instances have few custom fields, we have done field to field mapping and moved the Contract data from 'A' to 'B' using import set.

 

Now how to move the attachements from 'A' to 'B'? (sys_id's of contracts are different in both instances right, so I believe there is no straight way to move across instances). Is there a solution?

 

Note - This is a one time data migration activity that we need to do.

11 REPLIES 11

Bert_c1
Kilo Patron

Attachments are stored in the 'sys_attachment' table, where you can see those based on table_name and table_sys_id for specific records. Then export/retrieve the actual file content from the 'sys_attachment_doc' table for the specific 'sys_attachment' record (sys_id).  there is also a table named 'sys_attachment_doc_v2', but that table is empty in my instance.

Hi @Bert_c1  I have updated my question with more clarity. Can you please read it once again and let me know if you still have a solution?

Monique Rogers
Tera Contributor

@Monique Rogers I am looking to bulk import of attachments. I have updated my question with more clarity 🙂