I have an application currently working on the SQL Server 2012 and Microsoft stack.
I have a lot of images and documents which are required to be versioned and stored. Since the database was SQL Server, I was using Filetable & Filestream for storing the images and documents. Storing like is also meant I could work with SQL Server full text search for basic document search.
Now, I need to support Oracle also as a database. I wanted to check what would be the best way to ensure feature parity.
Based on my basic research BFile datatype should provide the similar features for storing the documents (except that the files are not a part of the database backup)
If I were to use BFile,
- Can the BFile be configured to be stored the documents on any network access share?
- Can OracleText be used to indexing and searching the content of the documents?
Are there any other database independent alternatives to storing the images and documents?
Since the deployment will be on-premise I cannot use s3 or any other cloud based solution.