Migrating encrypted attachments from once instance to another

[Chitra23]

Hi, 

We have a requirement to migrate the Security Incident Records from an old  instance to the new instance. We did an xml export and import of the SIR , audit , journal, emails and attachment tables to migrate the records.  Some of the attachments for the SIR records in the old instance are encrypted. When we try to access them in the new instance, we are getting "We can't open the file. Something went wrong " error message.  How do we access the encrypted attachment  in another instance?  Any guidance on this is highly appreciated.

Thanks

[ersureshbe]

Hi, Why Clone solution not tried and export / import selected? Any specific reasons?

If you clone the data from one to another instance you cant see the issues.

[Chitra23]

This is a re-implementation project and this data migration was not a part of the original scope. We are nearing the go live and cloning can't be done now. Can we export the key from the old instance to the new instance?

[ersureshbe]

Hi,

If export and import not help, you can try REST API explorer and try to add the attachment to the appropriate ticket for 1 or 2 tickets and test it. Perhaps, it supports and helping to see the right content then import solution not works. We should decide manual action using REST API explorer