Introduced in Feature Pack 2

Updating the version schema with the custom tables

Introduced in Feature Pack 2 The UpdateVersionSchema utility identifies which tables to be versioned, and then creates the tables in your version schema. This utility replicates newly added tables marked to be versioned from the base schema into the version schema. In this lesson, you will run the UpdateVersionSchema utility to automatically create the custom tables for Project and ProjectCollection in the version schema. For more information, please see: UpdateVersionSchema utility

About this task

Ensure your custom tables are created successfully in the version schema by checking the log file WCDE_installdir\logs\updateVersionSchema.log. The SQL is generated in the file WCDE_installdir\logs\Update_version_db_demo.sql.log.

For additional information about the UpdateVersionSchema utility, see UpdateVersionSchema utility.

Procedure

  1. Stop the WebSphere Commerce test server.
  2. From the command prompt, navigate to WCDE_installdir\bin .
  3. Run the command: updateVersionSchema.bat

Results