Version 9.0.0.79 does not re-enable DDL triggers after sync
NeM
Posts: 25
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
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
Comments
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.