Dictionary changes and update sets

Update sets prevent you from applying dictionary changes that result in data loss.

Blocked dictionary changes include:
  • Removing tables
  • Changing a column's data type

Update sets do not track the removal of tables from the system dictionary. Instead, customers must manually remove tables from the target instance.

While update sets track data type changes, the target instance skips any change that results in data loss and instead adds a log message about the action. Customers can use the log to manually make data type changes on the target instance.

Note: Update set previews do not check for type mismatch problems since the target instance skips changes resulting in data loss.