Script changes only to DML triggers

Forum for users of SQL Compare schema synchronization utility

Script changes only to DML triggers

Postby JoonaHook » Tue Apr 17, 2012 6:33 am

Is this possible by defining filters etc.?
Now I get basically drop/create of whole table first.
Posts: 9
Joined: Wed Nov 09, 2011 8:50 am

Postby Brian Donahue » Thu Apr 19, 2012 3:40 pm

SQL Compare will modify objects by ALTER wherever possible. However, for technical reasons imposed by SQL Server, sometimes objects have to be dropped and recreated.

We have a list of circumstances that would force a table drop - hopefully your situation matches one of these: ... 0708000113
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests