Skip to main content

I was looking to move our default storage repository

from Database → File storage

in an IFS cloud hosted environment  this to save space in our database.

 

Is there a clear overview of what the GAP is between the two repository types? 

  • Report rules only work in database? 
  • Can you just move files after a certain period (eg. 1 month) from database → FSS storage? 

So basically why would one use the database storage repository type and what are the implications of migrating from one repository type to another?

 

Thanks!

@Mathias Dahl 

 

(so this storage type: https://docs.ifs.com/techdocs/23r1/030_administration/210_cloud_file_storage/?_gl=1*xiu7ee*_ga*MTQzMjU3OTk4NC4xNzIwNzc1NDE3*_ga_H7YJR9R7Q1*MTcyMjM1MTUxMS45LjEuMTcyMjM1MjM0Ny41Ny4wLjA.#cloud_deployment

@kvbe 

Hi,

You are correct, archiving reports in Docman does not yet support File Storage. We want to solve that, but it's not done yet.

Another limitation is that media items (images) stored in FS cannot be included in reports.

Keeping files in FS also makes certain kinds of CRIMs harder, or impossible (when the file is in the database you can write PL/SQL code to do things with it).

I think that's about it.

Good luck!

 


@Mathias Dahl  we were investigating on the same lines. Our current database size is almost 2+tb with more than 1.7 of that being files. This makes clone and backup extremely time consuming.

 

What are the best practices customers are using as the DB sizes grows with files?


@PIINKADAM 

I'm not an expert on Oracle backup and recovery but I do know that combining incremental backups with full backups is a common approach.

Keeping the files outside the database is of course tempting but isn't free from problems. Now the references in the database to the files in external storage can in theory come out of sync since you have two different kinds of backups to handle.

Both approaches require careful planning if you host the IFS installation yourself. If you want to avoid that there is always the IFS managed option where our Cloud Services team takes care of everything.

 

 


 

@kvbe

Hi,

You are correct, archiving reports in Docman does not yet support File Storage. We want to solve that, but it's not done yet.

Another limitation is that media items (images) stored in FS cannot be included in reports.

Keeping files in FS also makes certain kinds of CRIMs harder, or impossible (when the file is in the database you can write PL/SQL code to do things with it).

I think that's about it.

Good luck!

 

We have been struggling with the media item issue with reports with support for a while.  It certainly isn’t clear and your explanation helps confirm my suspicions.  Thank you.

 Is there a work around for displaying media items stored in FS on reports?


@abyerly 

See my reply here:

https://community.ifs.com/document-management-docman-248/how-document-file-storage-using-azure-outside-the-cloud-database-works-49316?postid=174092#post174092

 


Reply