Particular / TimeoutMigrationTool

Other
4 stars 1 forks source link

Add support for MSMQ "native" SQL as timeout source #619

Open ramonsmits opened 7 months ago

ramonsmits commented 7 months ago

Describe the feature.

MSMQ v1.2 introduced native timeouts to the MSMQ transport. It used SQL Server as storage and is almost identical to the table schema for NHibernare/SQLP.

create table {0} (
        Id nvarchar(250) not null primary key,
        Destination nvarchar(200),
        State varbinary(max),
        Time datetime,
        Headers varbinary(max) not null,
        RetryCount INT NOT NULL default(0)
        )

Source: https://github.com/Particular/NServiceBus.Transport.Msmq/blob/release-1.2/src/NServiceBus.Transport.Msmq/DelayedDelivery/Sql/SqlConstants.cs

It would help customers migrate away from MSMQ.

Additional Context

No response