Search code examples
tridiontridion-2011tridion-content-delivery

Publish Content Broker DB in tridion

I am using SDL Tridion 2011 I want to know how to get the content published to Broker DB (SQL database) and binary assets (Images, Flash, CSS & JS) get published to filestream.

We have looked and tried to modify cd_storage_conf.xml and found the below for file system

<Storage Class="com.tridion.storage.filesystem.FSDAOFactory" Type="filesystem" Id="defaultDataFile"
 defaultFilesystem="false"><Root Path=" C:\applications\WebName\Publising_Data"/>

So similarly how the refernce to Brocker DB can be made, we are using SQL Database

Solution

  • I would suggest you to read how to configure storage from this link (Login required) first and then come come with specific question/problem.

    You may also search this over Google, you can find many articles about same.

    Use following storage types for SQL server and file system 

    <Storage Type="filesystem" Id="LocalFileSystem_01" defaultFilesystem="true" defaultStorage="true"
  Class="com.tridion.storage.filesystem.FSDAOFactory">
  <Root Path="STORAGE_PATH" />
</Storage>

    And then define the item type as per your requirement, here default is SQL server and I have override the for binary and pages to filesystem 

     <Item typeMapping="Page" cached="CACHE_BEHAVIOR" storageId="LocalFileSystem_01" />
<Item typeMapping="Binary" itemExtension=".EXT" cached="CACHE_BEHAVIOR" storageId="LocalFileSystem_01" />

</ItemTypes>