What are the challenges you face when working across database platforms? Take the survey
Options

Version 9.0.0.79 does not re-enable DDL triggers after sync

NeMNeM Posts: 25
edited June 9, 2011 4:22PM in SQL Compare Previous Versions
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

Comments

  • Options
    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. :)
Sign In or Register to comment.