Skip to main content

Hi,

 

   We have been using IFS for many years. Hence, we have lot of legacy data/obsolete data that we would like to do some clean up.  This data consists of IFS data and documents stored in db. as blob.

  Has anyone tried such exercise? Are there any best practices/tools on data archiving? If anyone could share some insights and experiences, it would be good. 

  We also plan to move to IFS Cloud next year.

 

Regards,

Rajesh A

 

 

  

I’ve used the Data Archiving functionality built into IFS for this, but it has some limitations to be aware of. Off the top of my head:

  • There is a lot of work in analysing table structures, so you don’t end up with orphan records or break object references. The data archiving bypasses all business logic and performs straight table deletes.
  • It doesn’t handle BLOBs and CLOBs (unless you simply want to delete them). Azure storage might be an option there.
  • You can only add a table once to each so-called data archive object, so archiving things like pre-postings and document texts can be painful. (I ended creating separate Data Archive Objects for PO headers and lines for instance.)
  • It doesn’t handle custom fields. (Because of triggers the custom field framework adds, records in custom fields tables are deleted when the “parent” record is copied to archive tables.)

Tech docs (for Apps 10): https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/default.htm

Reply


Terms & ConditionsCookie settings