Database Configuration
Learn how to configure Elsa Workflows to use different database providers for persistence, including SQL Server, PostgreSQL, and MongoDB.
Supported Database Providers
Prerequisites
Using SQL Server instead of SQLite
Configuring SQL Server
1. Install NuGet Packages
2. Configure Services
3. Connection String
Configuring PostgreSQL
1. Install NuGet Packages
2. Configure Services
3. Connection String
Configuring MongoDB
1. Install NuGet Packages
2. Configure Services
3. Connection String
Environment Variables
Running Migrations
1. Install EF Core Tools
2. Apply Migrations
3. Custom Migration Paths
Multi-Database Scenarios
Separate Databases Configuration
Benefits
Troubleshooting
Common Issues
1. Migration Errors
2. Connection Timeout
3. Permission Denied
4. MongoDB Connection Issues
Logging
Production Considerations
Performance Tuning
Security
Backup and Recovery
Monitoring
Next Steps
Last updated