Filter on table triggers ?
dlauwers
Posts: 2
Hi,
I am using SymmetricDS for replication purposes. This tool generates its own Table triggers to capture the data. We have our own triggers on tables as well.
If we compare 2 versions of our database, the Symmetric triggers are different and must NOT be synchronized. We can currently disable the DML Triggers, but then our own triggers are not compared !
We would like to filter on the name of the trigger of a table. All table triggers the start with SYM_ (in our case) must be ignored, all other triggers should be compared and synchronized if needed.
When a change on the table is detected, lets say a new column, and the table is synchronized the SYM_ triggers must also be ignored !
Is this possible ? How ?
And if it is not available, would it not be a good feature for the next version of SQL Compare ?
Thank
Danny
I am using SymmetricDS for replication purposes. This tool generates its own Table triggers to capture the data. We have our own triggers on tables as well.
If we compare 2 versions of our database, the Symmetric triggers are different and must NOT be synchronized. We can currently disable the DML Triggers, but then our own triggers are not compared !
We would like to filter on the name of the trigger of a table. All table triggers the start with SYM_ (in our case) must be ignored, all other triggers should be compared and synchronized if needed.
When a change on the table is detected, lets say a new column, and the table is synchronized the SYM_ triggers must also be ignored !
Is this possible ? How ?
And if it is not available, would it not be a good feature for the next version of SQL Compare ?
Thank
Danny
Comments
At the moment DML triggers are treated as part of the table definition so there's no way of filtering them. Sorry.
There's currently a feature request for this on our UserVoice site - https://redgate.uservoice.com/forums/14 ... from-table - I suggest that you vote for this and add any comments you may have.
Redgate Software