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

Version 9.0.0.79 does not re-enable DDL triggers after sync

Either I am missing something obvious here or there is a bug with this version..

Inside project options tab->under Behavior, I have checked the box that reads "Disable DDL triggers during synchronization"

However, when I script out the sync operation, the sql script shows:

PRINT N'Disabling DDL triggers'
GO
DISABLE TRIGGER ALL ON DATABASE
GO

But the ddl trigger re-enabling part is missing, I see just the print statement:

PRINT N'Re-enabling DDL triggers'
GO
NeM
0

Comments

1 comment

Sort by
  • NeM
    Not a bug - I was missing something obvious.

    The source environment had its DDL trigger disabled as well which was probably why the destination environment failed to show the sql statement to re-enable the DDL trigger. After re-enabling the DDL trigger in the source, the destination sync script did produce the re-enable DDL trigger sql statement. Sorry - false alarm. :)
    NeM
    0

Add comment

Please sign in to leave a comment.