Re: Triggers Control

[Roland Bouman]

Instead of using triggers, I'd try the following first:

1) create one table that has all the columns needed by all applications
2) load the data from the existing tables into the new table
3) drop the old tables
4) create updatable views for each old table.

The views would have the name of the old table. For each view, make sure the columnnames (and positions, some applications rely on positional information) are exactly similar to the table it substitutes.

This way, you won't touch any of the applications, and there's no synchronization issue at all.