UUID of Document

Mathieu Drouin It might be a convoluted process but I only have this way to do all this with safe side and storing file in some external storage, I can't say about this.

So you're neck-deep in a mess and trying to salvage the situation. Understood.

May I ask how you did this migration? Appian provides a service to fully migrate on-prem to cloud without loosing anything.

  , I created PM for each table where I'm fetching the data in a batch of 500 and soring them in cloud DB,

For documents, first it's table data migrated (as mentioned above), later migration of the documents started.

Documents stored as a base64 string , So on cloud we decrypt base 64 string and update the document ID of the generated document in Cloud DB.

I was not aware about any service to fully migrate on-prem to cloud without loosing anything, but please tell me the process and steps how to achieve this

And I think you get the solution or safe side I proposed above.

Thank you in advance

For migration, I suggest to contact Appian support or your Appian representative.

I'd suggest also you could use the Document MD5 via the "cryptographic hash functions" plug-in.  The MD5 would always be the same for a given document even cross-environment (and persisting across different exports/imports or even downloads / re-uploads) - the only way 2 documents would have the same md5 is if they're identical.  I used this functinality in the "offload documents to FTP" tool I built last year for my organization, and it went very well.