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 WebSphere Commerce-provided files within these directories.