Unable to import File sys_attachment_doc.xml

[CharanjeetSingh]

Hi All,
I am trying to migrate the records from one instance to another instance. I was able to import the sys_attachment table but when I am trying to import the sys_attachment_doc xml file after processing it is showing me the below message. 

File sys_attachment_doc.xml uploaded, use sys_attachment_doc.xml  to access it.
On clicking link it is giving error nothing on that page. Anyone please suggest how I can import the attachments effieciently.

TIA

[Ankur Bawiskar]

@CharanjeetSingh 

are you planning to migrate attachments from 1 instance to another? what's your business requirement here?

[CharanjeetSingh]

@Ankur Bawiskar I have to migrate the all incidents, change, problem records from single tenant instance to multitenant instance. So, I can export the other records without any issue but unable to import the attachment doc.

[Robbie]

Hi @CharanjeetSingh,

Rather than reinvent the wheel, please find the below links, one form the community and the other from ServiceNow support in achieving this.

Community link: https://www.servicenow.com/community/developer-forum/copying-attachment-from-one-instance-to-another... (Kudos @Michael Ritchie )

The ServiceNow support article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0790002

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[CharanjeetSingh]

Hi @Robbie,
Thanks for your response and guide. 
This seems good solution but it will create new records on the target instance and creating new record will result in new sys_id. If sys id will change it will lost the connection with other related records like Case, Incident tasks.