Running 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 you begin

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

Also, be sure you have a staging database loaded. For more information see, Loading the HCL Commerce Developer database schema.

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 you 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