Migration of Appian documents from one environment to another

Question

Hi All, 
 
 We have a scenario wherein the old application has records and associated attachments. The attachment ids are stored in the data base table corresponding to that record id. 
 As part of migration, we need to create new records having same data as old application records which can be done by just copying the data from old tables to new tables. 
 How do we migrate the attachments in this scenario? 
 1) Do we move the old record Appian attachments to the new folder and maintain the ids as it is in the new records? Will they still open up from UI? 
 2) Create new attachments and link to new records? 
 
 I believe approach 1 should work. Kindly advise. 
 Thanks. 
 Hitesh

naveenp878 · Answer

Hi Hitesh, 
 
I am afraid the first approach may not work. When we say attachment it is a document might be stored in in some KC and when we uploads Appian creates the ID and you are storing the ID in database. Now when we migrate (technically deploy) into another environment then the document ID will be different ! so, We along with the documents migration, we must update the database table ID coloum accordingly. 
 
So, Second approach might sounds better to me or else the above my suggestion we may look at. 
 
Thanks