Hangfire with MSSQL Merge Replication

sql-server
Tags: #<Tag:0x00007f6e43ea7dc0>

#1

Hi there!

Is it possible to apply Merge Replication for the hangfire tables in MSSQL?
We are currently getting the following error message:

‘The target table ‘JQ’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.’

The merge replication creates three triggers (INSERT/UPDATE/DELETE) on each table, which can’t be used with the OUTPUT clause used by Hangfire.SQLServer.

In the desired situation, we would like to run Hangfire on the main database and the replicated database.

Is there a solution or work around for this problem, or is it maybe impossible?


#2

I am facing the same issue. Do you got any solution on it ? @Alex1988