How can we help you today? How can we help you today?

Disabled Triggers not synchronizing properly

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
paulbarbin
0

Comments

1 comment

Sort by
  • JonathanWatts
    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.

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.