Administer > Manage WebSphere Commerce features > Enable Workspaces > Author server schema update tool
Run the authoring server update scripts on the development environment
Procedure
- Recalibrating a table.
If you have changed a table in the base schema, run the following script to recalibrate the table:
UpdateWorkspacesTable.bat -debug tableName [tableResourceType outputFile]
Where:
- tableName
- The name of the table to recalibrate.
- tableResourceType (optional)
- The table resource type. The valid input for this can be CONTENT_MANAGED, OPERATIONAL, and NON_MANAGED.
- outputFile (optional)
- Indicates that no database update should take 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.
- Recalibrating the entire schema If you have made many changes in the base schema and want the workspaces schema to reflect those changes, run the following script to recalibrate the entire schema:
UpdateWorkspacesSchema.bat -debug [outputFile]
Where:
- outputFile (optional)
- Indicates that no database update should take 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 accordingly.