Administer > Deploy > Deploying customized assets > Customized WebSphere Commerce database assets > Deploying custom database assets


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.

Regardless of which database you use, it is not recommended that you run complex SQL scripts when the WebSphere Commerce database is busy, since the SQL scripts will compete with the WebSphere Commerce application on database resources, such as for CPU or memory. In addition, the SQL statements in the scripts may need to lock the database resources (such as database records or tables), and this may affect the WebSphere Commerce application because of lock waiting or deadlock problems.

If you are making schema changes and are using the WebSphere Commerce workspaces feature, it is important that you also invoke the authoring server schema update utility when deploying these changes to your authoring server environment.


Procedure


Related concepts

Author server schema update tool


Related tasks

Deploy custom database assets


+

Search Tips   |   Advanced Search