Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Can you store a file in a database?

Contents
  1. Can files be stored in a SQL database?
  2. Should you store files in a database or file system?
Reasons in favor of storing files in the database: Having the files and database in sync and able to participate in transactions can be very useful. Files go with the database and cannot be orphaned from it. Backups automatically include the file binaries. 29 мая 2012 г.


Can files be stored in a SQL database?

The FileTable feature enables enterprise customers to store unstructured file data, and directory hierarchies, in a SQL Server database. The feature addresses the requirements for non-transactional access and Windows application compatibility for file-based data.

Should you store files in a database or file system?

Database provides a proper data recovery process while file system did not. In terms of security the database is more secure then the file system (usually). The migration process is very easy in File system just copy and paste into the target while for database this task is not as simple.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours