Devart Forums

Hi,

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

If 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

Can I disable this "CREATE OR ALTER" functionality in dbForge Schema Compare? Our current version 4.4.61

Regards,
ganendran

Please use the 'Use DROP and CREATE instead of ALTER for views, procedures, functions and triggers' option on the 'Options' page of the schema synchronization wizard.

Hi,

Schema changes are only replicated to the subscriber if I execute the trigger as ALTER ... (Drop and create won't populate to the subscribers with merge replication)

Al also I tried the "DROP AND CREATE" method, but still the script is generated with "CREATE OR ALTER"

Could you please clarify this? If we understand you correctly, you need it to generate "ALTER TRIGGER..." instead of "CREATE OR ALTER TRIGGER..." in the sync script for object modifying.

Hi,

Yes that would be nice if the script generate "ALTER trigger ..." instead of "CREATE or ALTER Trigger ..."
Regards,
Ganendran

Hello,

We have planned this function to be available in the future product builds.

Hi,

In the previous version you solved this with 'ALTER statement', today I installed the new version "dbForge Compare Bundle for SQL Server Professional' version 5.7.22, and it is again with "CREATE OR ALTER"

Regards,
Ganendran

For, SQL Server 2016 (version 13.0.1601.5), dbForge generates a sync script with "CREATE" and "ALTER" for procedures, views, functions and triggers as it does for SQL Server 2012 and 2014.

For, SQL Server 2016 SP1 (version 13.0.4001.0) and higher dbForge generates a script with "CREATE OR ALTER".

Hi Alexa,
Yes, uou made the changes correctly with the previous compare bundle version with 'ALTER' but now with the new version its again 'CREATE OR ALTER' if you have a merge replication and when you execute the script ex. CREATE OR ALTER trigger.. then the trigger won't replicate to the subscriber(s).

Compare bundle 5.7.1 'CREATE OR ALTER'
Compare bundle 5.7.20 'ALTER'
Compare bundle 5.7.22 'CREATE OR ALTER'

Could you please provide us the server's version you are experiencing issues with?

Hi,

Server version : Microsoft SQL Server 2016 (SP1-CU3) (KB4019916) - 13.0.4435.0 (X64)

If you read de full issue comments here I already asked to add this feature and you already made changes I think because it worked in de previous version but I don't know why it changed back again. Replicated triggers only replicated to the subscribers with 'ALTER' statement.

https://docs.microsoft.com/en-us/sql/re ... erver-2017

Sorry for the delay on this. We will fix this in one of the next product versions.