Disabled Triggers not synchronizing properly

paulbarbinpaulbarbin Posts: 9
edited June 19, 2007 7:12AM in SQL Compare Previous Versions
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,

    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.


    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.