How to move attachments from 1 ServiceNow instance to another ServiceNow instance?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2024 12:11 PM - edited 05-03-2024 01:07 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2024 01:04 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 12:56 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2024 01:27 PM - edited 05-01-2024 01:28 PM
You can send attachments between instances via REST.
https://www.servicenow.com/community/developer-forum/how-can-i-send-attachment-from-one-servicenow-i...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 12:57 AM
@Monique Rogers I am looking to bulk import of attachments. I have updated my question with more clarity 🙂