We have some merge replication tables, when we made some changes in triggers on DEV environment and want push those changes to production envirnment with dbForge schema comapre it creates a script like
EXEC sp_executesql N'CREATE OR ALTER TRIGGER ...
But replication works only with "ALTER TRIGGER ...", when I execute script the schema change won't replicate to the subscribers.
BOL: https://docs.microsoft.com/en-us/sql/re ... erver-2017
Can I disable this "CREATE OR ALTER" functionality in dbForge Schema Compare? Our current version 4.4.61If you make the following schema changes to a published article, they are propagated, by default, to Microsoft SQL Server Subscribers:
ALTER TABLE
ALTER VIEW
ALTER PROCEDURE
ALTER FUNCTION
ALTER TRIGGER
Regards,
ganendran