Version v1.x

SQL Server

Available in

.NET Node.js Python

Configure DurableStack with SQL Server for durable shared-state execution.

SQL Server is a durable provider option for environments standardized on Microsoft data infrastructure.

It supports shared run coordination across workers through the same DurableStack contract.

Registration

using DurableStack.Hosting.DependencyInjection;

var connectionString = "Server=localhost;Database=durable_stack;User Id=sa;Password=Password123!;TrustServerCertificate=true";

builder.Services.AddDurableStackSqlServer(connectionString, options =>
{
    options.WorkerName = $"billing-api-{Environment.MachineName}-{Environment.ProcessId}";
});

import { createDurableStackSqlServer } from "durablestack";

const { runtime } = await createDurableStackSqlServer(
  { connectionString: process.env.SQLSERVER_URL! },
  {
    workerName: `billing-api-${process.pid}`
  }
);

Operational notes

Prefer secure transport settings in production (Encrypt=True, trusted cert chain).
Validate lock/throughput behavior under expected concurrency.
Keep table-prefix strategy consistent across environments if used.