Administer > Manage WebSphere Commerce features > Enable Workspaces > Author server schema update tool

Run the authoring server update scripts on the WebSphere Commerce Server

You can use the authoring server update scripts to do one of the following tasks:

• Recalibrate a table
• Recalibrate the entire schema

When running the config_ant scripts make sure that you have met the following conditions:

• Make sure that the WebSphere Commerce Server is not running since this tool is updating the workspace schema structure.

• The createInstance.properties file must exist for this Ant script to work.

  To change property values, modify...

  WC_INSTALL/instances/instance/properties/createInstance.properties

Run the config_ant tool under...

WC_INSTALL/bin

Do not run the config_ant tool under any db2cmd prompt in Windows.

Recalibrate a single table

If you have changed a table in the base schema, to recalibrate the table:

WC_INSTALL/bin/config_ant.sh \
    -buildfile WC_INSTALL/components/Workspaces/xml/updateWorkspacesSchemaTable.xml \
    -DinstanceName=instance \
    -DdbaPassword=administrative_password \
    -DtableName=tableName \
    -DtableResourceType=tableResourceType \
    -DresourceXMLLocation=location_of_resource_XML_Files \
    -DgenerateSQLStatementsOnly=true|false \
    -DgenerateSQLStatementsOutputFile=outputFileDirectory \
    -DdebugMode=true \
    CM_updateWorkspacesTable 

This Ant script takes a single table from the base schema and updates the table in the workspaces.

This text is wrapped for display purposes. Enter the command on one line.

Recalibrate the entire schema

If you have made many changes in the base schema and want the workspaces schema to reflect those changes, to recalibrate the entire schema:

WC_INSTALL/bin/config_ant.sh \
    -buildfile WC_INSTALL/components/Workspaces/xml/updateWorkspacesSchema.xml \
    -DinstanceName=instance \
    -DdbaPassword=administrative_password \
    -DresourceXMLLocation=location_of_resource_XML_Files \
    -DgenerateSQLStatementsOnly=true|false \
    -DgenerateSQLStatementsOutputFile=outputFileDirectory \
    -DdebugMode=true \
    CM_updateWorkspacesSchema  

This Ant script scans through the base schema and adjusts the workspaces schema accordingly.

This text is wrapped for display purposes. Enter the command on one line.

+

Search Tips   |   Advanced Search