Packaging custom database assets

There is no standard packaging format for database assets. If you make database changes and move the assets from one system to another during the overall deployment process, use an archiving utility that is supported by your operating system such as TAR, ZIP, or JAR archiving utility.

About this task

The assets that are required for database changes can include:

  • SQL files
  • Loader utility XML files
  • Access control XML files
  • Command scripts

The recommended directory structure to build for this package would be:

Type of file Directory structure
Access control policy files WC_installdir/xml/policies/xml
SQL files WC_installdir/sql for SQL files
Loader utility files WC_installdir/xml for Loader utility files

Do not replace any HCL Commerce-provided files within these directories.