update sets

FujiForty - Update Synch, the New Way

When creating new tables for an application they can generally be classified into two categories, configuration and data. Configuration records are general application settings or process information, and usually needs to exist for the application to work correctly. This means that they should be consistent between dev, test, and production instances so we need a way to migrate these records when they are changed. In pre-Fuji releases configuration data tables were defined by using the update_synch attribute on the table. Inserts and updates of records on update_synch tables are captured in update sets which can be moved between instance environments.