Create database against Azure needs to more resilient.

dbcli / mssql-cli

A command-line client for SQL Server with auto-completion and syntax highlighting

BSD 3-Clause "New" or "Revised" License

1.35k stars 191 forks source link

Create database against Azure needs to more resilient. #280

Closed pensivebrian closed 4 years ago

pensivebrian commented 4 years ago

If the cloud is having a bad day, a create database statement may fail with a command timeout, but the operation may be in-progress. We should check the server sys.dm_operation_status DMV for the status of the create database operation, and poll until the create database operation completes.

ellbosch commented 4 years ago

Note: leverage dacfx create db modifier.