How to configure different persistence's for saga and outbox

#1

We are already using Azure CosmosDb for our Saga persistence, but our primary business data store is SQL Server.

We now have a requirement for Outbox pattern, can nservicebus support one persistence store of Sagas and another persistence for outbox ?

a sample configuration would really be helpful.

Thanks -nen

#2

Hi @Nen_Zax

The Outbox is designed to achieve “exactly once”-like behavior similar to distributed transactions, without using distributed transactions. For this to work, all storage operations (outbox, sagas, and business data) need to use the same database. Therefore, it doesn’t really make sense to use different storages when planning to use the outbox.

We have some more in-depth documentation about the outbox here: Outbox • NServiceBus • Particular Docs