Developer forum

Forum » CMS - Standard features » Deployment of items from database

Deployment of items from database

Anders Ebdrup
Anders Ebdrup
Reply

Hello,

 

I am trying to figure out how to get items from the database deployed with the new deployment tool? Does anyone know how that works?

 

Best regards, Anders


Replies

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply

Hi Anders,

Is it items or is it something else?

Items are automatically transferred when you deploy areas, pages and paragraphs (Settings > Developer > Deployment > Content).

If you are trying to transfer raw data from some table then you can create a custom configuration and use the SqlDataItemProvider. Something like this...

<DataGroup Id="MyDataGroup">
  <DataItemTypes>
    <DataItemType Id="MyData" ProviderTypeName="Dynamicweb.Deployment.DataItemProviders.Sql.SqlDataItemProvider">
      <ProviderParameters>
        <Parameter Name="Table" Value="MyCustomTable" />
      </ProviderParameters>
    </DataItemType>
  </DataItemTypes>
</DataGroup>

The configuration should be placed in the folder /Files/System/Deployment/DataGroups

Documentation is here: http://doc.dynamicweb.com/documentation-9/platform/platform-tools/deployment-tool

Best regards,
Morten

 
Anders Ebdrup
Anders Ebdrup
Reply

Hi Morten,

 

I am trying to deploy only the item structures which is defined in the database, and this does not seem to do the trick as it is for files:

 

    <DataItemType Id="ItemTypes" Name="Item types" ProviderTypeName="Dynamicweb.Deployment.DataItemProviders.Files.FilesDataItemProvider">
      <ProviderParameters>
        <Parameter Name="RecursiveSearch" Value="false" />
        <Parameter Name="TargetPath" Value="/Files/System/Items" />
      </ProviderParameters>
    </DataItemType>

Should I use another provider?

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply

You should be able to do that using the SqlDataItemProvider...

<DataItemType Id="ItemTypesDatabase" Name="Item types (database)" ProviderTypeName="Dynamicweb.Deployment.DataItemProviders.Sql.SqlDataItemProvider">
  <ProviderParameters>
    <Parameter Name="Table" Value="ItemTypeDefinitions" />
  </ProviderParameters>
</DataItemType>

 

You must be logged in to post in the forum