Migrating Attachments from ServiceNow to an Archive Database

To migrate record attachments from ServiceNow to a Database, you must first create the Attachments table using the Generate->Create Attachment Table option from the Project menu:

Note this option is only enabled for ServiceNow->DB projects.  The table created is called sn_sys_attachment and has similar columns to the attachment table in ServiceNow.

Once the attachment table is created you can configure your project to migrate attachments for the corresponding Form Mappings.

To migrate all the attachments for a given table, select the Options tab for the corresponding Form Mapping and select the All Attachments option.

When this option is selected, all attachments for records that are themselves migrated are also migrated to the attachment table in your database. Note that if the record contains images, these will also be migrated.

In the Execution settings, you can redirect the attachment content to a file system or S3 bucket. In this case, the attachment table will record, for each attachment, the location of the attachment.

Note for Large Attachments:

Large attachments may fail if downloading the attachment from Service Now takes too long. By default, this operation will timeout with an error after 60 seconds. To increase this timeout and allow larger attachments make the following change to the Service Now Server.

1. Navigate to System Definition-> Transaction Quota Rules
2. Search for the rule named 'REST Attachment API request timeout'
3. Increase the value from the default of 60 seconds to a recommended 600 seconds.