Disabled Triggers not synchronizing properly
paulbarbin
Posts: 9
I have some triggers that exist on one database that do not exist on the other however when they are added to the new db, they are disabled. This is an automated process based on data in the db. Some dbs will have the triggers enabled and some will not.
When I run the synchronize, it doesn't seem to care whether the trigger is enabled or disabled, it just adds it to the sync'd db.
Is there an option that I'm missing?
Paul
When I run the synchronize, it doesn't seem to care whether the trigger is enabled or disabled, it just adds it to the sync'd db.
Is there an option that I'm missing?
Paul
Comments
No there isn't anything wrong, SQL Compare does not support synchronising the status of triggers at the current time. We probably should address this, I will add a request to the system for future versions of SQL Compare to support this.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd