microsoft / durabletask-mssql

Microsoft SQL storage provider for Durable Functions and the Durable Task Framework
MIT License
87 stars 32 forks source link

Automatically Create Database If Not Present #48

Closed wsugarman closed 2 years ago

wsugarman commented 2 years ago

This extension is very easy-to-use with a simple configuration change and package import! But unlike the default Azure Storage option, the SQL provider requires that you create the database ahead of time. This isn't very convenient, especially because there may be settings, like the collation, that may only be discovered in the docs. I have also been playing around with azure functions using docker-compose, and it would require less overhead to simply spool up my SQL and Azure Function containers without executing an additional script to create my DB.

If that sounds like something you'd like to include as part of this storage provider, I have created a pull request to demonstrate the start of such a change.

wsugarman commented 2 years ago

This change has been merged.