Resize database columns

About this task

After the PolicyCenter database is in use, you might discover that you need to change the size of certain columns, such as making a column name longer. PolicyCenter does not provide an automated way of doing this. However, the following commonly used procedure provides a general outline of the steps involved making this kind of database change.

Important: Guidewire does not support re-sizing any database columns that are part of the PolicyCenter base configuration.

Procedure

  1. Shut down PolicyCenter.
  2. Alter the table and add a new temporary column that is the new size.
  3. Copy all of the data from the source column to the temporary column.
  4. Alter the table and drop the source column.

    Depending on the database, it is possible that you need to set the data in this column to all nulls before you can drop the column.

  5. Alter the table and add the new source column that is the new size.
  6. Copy the data from the temporary column to the new source column.
  7. Alter the table and drop the temporary column.
  8. Restart PolicyCenter.