[DOC] How to use SQLServer instead of SqlLite in Els3.0?

[Prameelagr8]

Documentation Improvement Request

Documentation Issue Overview

How to use SQLServer instead of SqlLite in Els3.0?

Proposed Documentation Changes

It is very important to know how to migrate the database to SQlServer. We are using elsa for our flow and our system needs MSSQL as centralised database system.

Additional Context

Please let me know how to change SQLLite to SQLServer. For example, if we need to use MSSQL then we need tables, Procs(if any) used by elsa system. If there is any migration script. Please provide all steps i.e., compatable with Elsa3.0.
Please let me know steps ASAP.

[sfmskywalker]

We definitely need to document this, thanks for creating an issue about it. Until we have this documented, take a look at the reference project Elsa.Server.Web: https://github.com/elsa-workflows/elsa-core/blob/main/src/apps/Elsa.Server.Web/Program.cs#L134

Just like with SQLite, the SQL Server provider can execute migrations automatically at application startup. Or, you can disable that, and execute the migrations yourself, or from your build pipeline, etc.