Reputation: 704
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,
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.
Upvotes: 0
Views: 472