How can we help you today?

How can we help you today?

Migration Scripts Disable DDL Triggers

Is there anyway to stop the migration script from disabling our DDL Triggers? It puts

PRINT N'Disabling DDL triggers'
GO
DISABLE TRIGGER ALL ON DATABASE
GO
at the start of the migration script and then enables them afterwards.

SharonBB May 11, 2017 09:24

0

Comments

1 comment

There's a comparison option to control that behaviour (https://documentation.red-gate.com/display/SOC5/Change+the+comparison+options) - you want to turn off 'Disable DDL triggers during deployment'.

Mike U May 11, 2017 13:09

0

Add comment

Please sign in to leave a comment.