(Developer)

(Professional) (Enterprise)

Run authoring environment update scripts

Use the updateWorkspacesSchema and updateWorkspacesTable utilities when you change your base schema or make schema changes to a table and need to update your workspaces schema to include the changes.

Before beginning

Ensure that the development environment is configured for workspaces. See Configure workspaces.

Procedure

• Updating a workspaces table.

  If you change a table in the base schema, run the following script to update the table in the workspaces schema to include the changes:

  UpdateWorkspacesTable.bat -debug tableName [tableResourceType outputFile]

  Where:

  tableName

  The name of the table we want to update.

  tableResourceType

  Optional. The table resource type. The valid input for this parameter can be CONTENT_MANAGED, OPERATIONAL, and NON_MANAGED.

  outputFile

  Optional. Indicates that no database update takes place. The SQL statements are written to this output file.

  debug

  Optional. Indicates that trace and log information is enabled.

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

  If you need to review the log for this utility, the logging information is included in the following log file:
  WCDE_installdir\logs\updateWorkspacesTable.log

• Updating the entire workspaces schema If you change the base schema and want the workspaces schema to reflect those changes, run the following script to update the entire workspaces schema to include the changes:

  UpdateWorkspacesSchema.bat -debug [outputFile]

  Where:

  outputFile

  Optional. Indicates that no database update takes place. The SQL statements are written to this output file.

  debug

  Optional. Indicates that trace and log information is enabled.

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

  If you need to review the log for this utility, the logging information is included in the following log file:
  WCDE_installdir\logs\updateWorkspacesSchema.log

Related concepts
Workspaces overview

Related tasks
Enable e-mail notification for workspaces
Enable Workspaces in the WebSphere Commerce development environment
Creating an authoring environment
Configure a transport method for the site
Assigning a message type to a transport method for a site or store