bulk import/ export of data (including attachments);

[jmadhuri]

Hi,

Could you please let me know if there is a tool for doing bulk import/ export of data (including attachments);?

We have a scenario where we need to bulk export all the records one Service Now instance to another along with attachments (if any). Do we have an option to do this?

Thanks,

Jaya

[sergiu_panaite]

Forgot to mention that attachments are also compressed first (zipped). If you go to sys_attachment.list and add columns: Compressed, Size bytes, Size compressed you will see what I am referring to.

Also, if you look in Dictionary for sys_attachment_doc table on "data" column you will see it has a limit of 4000.

Regards,

Sergiu

[garrett_prochno]

Hi Jaya,

Perspectium Replicator is a perfect solution for this. As a native ServiceNow application, attachments can be imported/exported by simply checking a box on the share or subscribe configuration. No need to deal with the complexity of mapping sys_attachment with the sys_attachment_doc 4k chunks, base64 encoding/decoding, etc. Same goes for journal fields/history/audit.

--Garrett Prochnow

www.perspectium.com