Administer > Deploy > Deploying customized assets > Customized WebSphere Commerce database assets
Deploy custom database assets
Depending on the type of database asset you have customized, we will use a different deployment tool. The deployment tool will also vary depending on the database vendor that you are using.
Deploy database assets involves:
- Deploy schema changes
Schema changes involve adding or altering tables in the target WebSphere Commerce database. These actions are typically stored in SQL files. Each database vendor provides a means for running SQL files.
- Deploy access control policies
Access control is crucial to any business, and is especially important if you plan to customize access control policies. Ensure that you are familiar with WebSphere Commerce access control. An access control policy authorizes a group of users to perform a set of actions on a set of resources within WebSphere Commerce. Unless authorized through one or more access control policies, users have no access to any functions of the system.
- Load changed assets for deployment
If you have many changed database asset files to deploy, use the WebSphere Commerce loading utilities to help with this task. The idresgen utility generates identifiers for XML elements, and the massload utility loads data into the WebSphere Commerce database.
Previous topic: Package custom database assets
Related tasks
Package custom database assets
Related reference
Troubleshoot: Running SQL scripts