Run the authoring server update scripts on the development environment
- 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 you want 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.
Related concepts
Authoring server schema update tool
Workspaces
Authoring serverRelated tasks
Run the authoring server update scripts on the WebSphere Commerce Server