Allow DDL inside transactions (better support for devops tools)
Allow DDL inside of a transaction.
This would allow for greater support of testing tools, many use transactions to unit test code. (such as redgate)
It would also provide an environment to allow atomic deployments, where any failed deployment can be rolled back. (potentially allowing flyway support, especially as Micorosoft have no source control/deployment soultion for SQL DW)
Thank you for your request. This item is on our backlog. We will update the thread when the status changes.
Sune Boesgaard Krog-Meyer commented
This would be super useful for me as well