Search code examples
sensenet

Where are the all documents/files physically stores in Sense/Net after uploading?

I a trying to figure out where all documents physically stores after uploading on portal. I find out nodes table in database which show the path of documents. i want to know path of document storage and how i can change default document storage location or give new disk path location.

Solution

  • In Sense/Net everything is stored in the Content Repository, meaning the database by default. You can switch on the FileStream feature of MS SQL Server, Sense/Net supports that, but that feature will be phased out in the future, because SQL Server uses too much storage in some environments.

    There is a possibility to store binaries in a separate blob storage. The Enterprise edition contains a blob provider for MongoDb; Community users may create a custom solution based on a sample code.

    In the default installation these are the SQL tables that you can take a look at:

    • Nodes (as you have found out, this is the central table).
    • Versions: one or more versions per content (can be joined with Nodes).
    • BinaryProperties: metadata table for binary values (can be joined to Versions).
    • Files: real binary data in case of default behavior, connected to the BinaryProperties table above.

    For details, see this article: Sense/Net database structure