advantys/workflowgen-sql repository overview

docker volume create wfgen-sql-data
docker run -d --name wfgen-sql --env-file ./database.env \
  -v wfgen-sql-data:/var/opt/mssql -p 1433:1433 \
  advantys/workflowgen-sql:10.3.0-ubuntu-24.04

docker volume create wfgen-sql-data
docker run -d --name wfgen-sql --env-file .\database.env `
  -v wfgen-sql-data:C:\wfgen\sql -p 1433:1433 `
  advantys/workflowgen-sql:10.3.0-express-win-ltsc2019

docker volume create wfgen-sql-data
docker run -d --name wfgen-sql --env-file ./database.env \
  -v wfgen-sql-data:/var/opt/mssql -p 1433:1433 \
  advantys/workflowgen-sql:9.6.0-ubuntu-22.04

# Create volume for database persistence
docker volume create wfgen-sql-data

# Run container (examples: 9.6.0 or 8.3.5)
docker run -d `
  --name wfgen-sql `
  --env-file .\database.env `
  -v wfgen-sql-data:C:\wfgen\sql `
  -p 1433:1433 `
  advantys/workflowgen-sql:9.6.0-express-win-ltsc2019
  
# Or, for Windows Server 2022:
# advantys/workflowgen-sql:9.6.0-express-win-ltsc2022
  
# Or for v8:
# advantys/workflowgen-sql:8.3.5-express-win-ltsc2019

# database.env for Linux
SA_PASSWORD=yourStrong(!)Password
WFGEN_DATABASE_USER_PASSWORD=myStrong(?)Password
ACCEPT_EULA=Y
MSSQL_PID=Express  # Free for production use

WFGEN_DATABASE_CONNECTION_STRING=Data Source=wfgen-sql;Initial Catalog=WFGEN;User ID=WFGEN_USER;Password=<your-password>;TrustServerCertificate=True

WFGEN_DATABASE_CONNECTION_STRING=Data Source=wfgen-sql;Initial Catalog=WFGEN;User ID=sa;Password=<SA-password>;TrustServerCertificate=True

# Create secrets
echo "yourStrong(!)Password" | docker secret create SA_PASSWORD -
echo "myStrong(?)Password" | docker secret create WFGEN_DATABASE_USER_PASSWORD -

# Create service with secrets
docker service create \
  --name wfgen-sql \
  --secret SA_PASSWORD \
  --secret WFGEN_DATABASE_USER_PASSWORD \
  -e SA_PASSWORD_FILE=/run/secrets/SA_PASSWORD \
  -e WFGEN_DATABASE_USER_PASSWORD_FILE=/run/secrets/WFGEN_DATABASE_USER_PASSWORD \
  -e ACCEPT_EULA=Y \
  advantys/workflowgen-sql:9.6.0-ubuntu-22.04

# Create secrets
docker secret create SA_PASSWORD "yourStrong(!)Password"
docker secret create WFGEN_DATABASE_USER_PASSWORD "myStrong(?)Password"

# Create service with secrets
docker service create `
  --name wfgen-sql `
  --secret SA_PASSWORD `
  --secret WFGEN_DATABASE_USER_PASSWORD `
  -e SA_PASSWORD_FILE=C:\ProgramData\Docker\secrets\SA_PASSWORD `
  -e WFGEN_DATABASE_USER_PASSWORD_FILE=C:\ProgramData\Docker\secrets\WFGEN_DATABASE_USER_PASSWORD `
  -e ACCEPT_EULA=Y `
  advantys/workflowgen-sql:9.6.0-express-win-ltsc2019

# Required
SA_PASSWORD=yourStrong(!)Password
WFGEN_DATABASE_USER_PASSWORD=myStrong(?)Password

# Required for Linux only
ACCEPT_EULA=Y

# Recommended for v10 Linux (specify SQL Server edition)
MSSQL_PID=Developer

# Optional
WFGEN_DATABASE_CONTAINMENT=Y
WFGEN_DATABASE_USER_USERNAME=WFGEN_USER
WFGEN_ADMIN_USERNAME=wfgen_admin
WFGEN_ADMIN_PASSWORD=admin123
WFGEN_AUTH_APPLICATION=Y

# v10 Linux
docker run -d --env-file ./database.env advantys/workflowgen-sql:10.3.0-ubuntu-24.04

# v9 Linux
docker run -d --env-file ./database.env advantys/workflowgen-sql:9.6.0-ubuntu-22.04

# v8/v9 Windows
docker run -d --env-file .\database.env advantys/workflowgen-sql:9.6.0-express-win-ltsc2019

# Using named volume (recommended)
docker volume create wfgen-sql-data
docker run -d -v wfgen-sql-data:/var/opt/mssql advantys/workflowgen-sql:10.3.0-ubuntu-24.04

# Using bind mount
docker run -d -v /host/path/to/mssql:/var/opt/mssql advantys/workflowgen-sql:9.6.0-ubuntu-22.04

# Using named volume (recommended)
docker volume create wfgen-sql-data

# v10 (SQL Server 2025)
docker run -d -v wfgen-sql-data:C:\wfgen\sql advantys/workflowgen-sql:10.3.0-express-win-ltsc2019

# v9 (SQL Server 2017/2022)
docker run -d -v wfgen-sql-data:C:\wfgen\sql advantys/workflowgen-sql:9.6.0-express-win-ltsc2019

# Using bind mount
docker run -d -v C:\host\path:C:\wfgen\sql advantys/workflowgen-sql:9.6.0-express-win-ltsc2019

# Interactive PowerShell session
docker exec -it wfgen-sql pwsh

# Execute single command
docker exec wfgen-sql pwsh -Command "Get-Date"

# Interactive PowerShell session
docker exec -it wfgen-sql powershell

# Execute single command
docker exec wfgen-sql powershell -Command "Get-Date"

# Interactive bash session
docker exec -it wfgen-sql bash

# Execute single command
docker exec wfgen-sql bash -c "ls -la /var/opt/mssql"

# v10 Linux
docker run -d -p 1433:1433 --env-file ./database.env advantys/workflowgen-sql:10.3.0-ubuntu-24.04

# v9 Linux
docker run -d -p 1433:1433 --env-file ./database.env advantys/workflowgen-sql:9.6.0-ubuntu-22.04

# v10 Windows
docker run -d -p 1433:1433 --env-file .\database.env advantys/workflowgen-sql:10.3.0-express-win-ltsc2019

# v8/v9 Windows
docker run -d -p 1433:1433 --env-file .\database.env advantys/workflowgen-sql:9.6.0-express-win-ltsc2019

# Stop container (preserves data if volumes are mapped)
docker stop wfgen-sql

# Start existing container
docker start wfgen-sql

# Restart container
docker restart wfgen-sql

# Remove container (data persists in volumes)
docker rm wfgen-sql

# View container logs
docker logs wfgen-sql

# Follow logs in real-time
docker logs -f wfgen-sql

# View last 100 lines
docker logs --tail 100 wfgen-sql

# Check container status
docker ps --filter name=wfgen-sql

# Verify database is accessible
docker exec wfgen-sql pwsh -Command "Invoke-Sqlcmd -Query 'SELECT DB_NAME()' -Database WFGEN -ServerInstance localhost"

# Verify WorkflowGen tables exist (should return 55+ tables)
docker exec wfgen-sql pwsh -Command "Invoke-Sqlcmd -Query 'SELECT COUNT(*) AS TableCount FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ''dbo''' -Database WFGEN -ServerInstance localhost"

# Check admin user
docker exec wfgen-sql pwsh -Command "Invoke-Sqlcmd -Query 'SELECT TOP 1 USERNAME FROM USERS WHERE ID_USER = 1' -Database WFGEN -ServerInstance localhost"

# Linux - Backup to container
docker exec wfgen-sql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '<SA_PASSWORD>' \
  -Q "BACKUP DATABASE [WFGEN] TO DISK = N'/var/opt/mssql/backup/WFGEN.bak' WITH NOFORMAT, NOINIT, NAME = 'WFGEN-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

# Copy backup to host
docker cp wfgen-sql:/var/opt/mssql/backup/WFGEN.bak ./WFGEN_backup.bak

# Windows (v8, v9) - Backup to container
docker exec wfgen-sql powershell -Command "Invoke-Sqlcmd -Query \"BACKUP DATABASE [WFGEN] TO DISK = N'C:\wfgen\sql\WFGEN.bak'\" -ServerInstance localhost -Username sa -Password '<SA_PASSWORD>'"

# Copy backup to host
docker cp wfgen-sql:C:\wfgen\sql\WFGEN.bak .\WFGEN_backup.bak

# Linux - Copy backup to container
docker cp ./WFGEN_backup.bak wfgen-sql:/var/opt/mssql/backup/

# Restore database
docker exec wfgen-sql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '<SA_PASSWORD>' \
  -Q "RESTORE DATABASE [WFGEN] FROM DISK = N'/var/opt/mssql/backup/WFGEN_backup.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"

docker logs wfgen-sql

docker ps --filter name=wfgen-sql

docker port wfgen-sql

docker exec wfgen-sql pwsh -Command "Invoke-Sqlcmd -Query 'SELECT @@VERSION' -ServerInstance localhost"

docker logs -f wfgen-sql

# Should return approximately 55 tables
docker exec wfgen-sql pwsh -Command "Invoke-Sqlcmd -Query 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ''dbo''' -Database WFGEN"