CREATE DATABASE in a migration about evolve HOT 8 CLOSED

Addressed by #150

Evolve 2.4.0 will support SQL statements like CREATE DATABASE in special migrations that execute outside of a transaction. To use this feature add this comment in the first line of your migration script: evolve-tx-off.

-- evolve-tx-off
create database evolveshared

from evolve.

Like documented here CREATE DATABASE statement is not supported because of the need to execute it in a separate transaction, which is not supported by Evolve in the same sql file (1 file = 1 big transaction).

I would try to isolate this statement in a separate migration file and execute the next statements in another migration file(s).

Keep me in touch with the results, because I can not test it for now and I'm curious about the results.

Thanks for your feedback :)

from evolve.

Thanks for your quick response!
This is the only statement in the migration I'm running (I have started from a number of statements in one migration and moved to only one).
Also tried not dynamically ('CREATE DATABASE [evolveshared]') and got the same result.

from evolve.

Ok, that's why it is not supported finally ^^ I remember now :) This statement dos not support transaction. And since Evolve always wraps migrations in a transaction, it fails. So while waiting for an evolution of Evolve (which could be possible when the new SqlStatementBuilderBase will be released by the way), use CREATE DATABASE in your scripts is not possible at all. Sorry

from evolve.

OK. Thank you for your time :)

from evolve.

@lecaillon When you say "an evolution of Evolve", do you mean that this is something that will be supported at some point? If so, do you have a roadmap for this support? We might be able to support the development on a professional basis.

from evolve.

Addressed by #150

Evolve 2.4.0 will support SQL statements like CREATE DATABASE in special migrations that execute outside of a transaction. To use this feature add this comment in the first line of your migration script: evolve-tx-off.

-- evolve-tx-off
create database evolveshared

while runnig above script getting an error that [dbname] is not exist. Evolve version is 3.0.0

from evolve.

Addressed by #150
Evolve 2.4.0 will support SQL statements like CREATE DATABASE in special migrations that execute outside of a transaction. To use this feature add this comment in the first line of your migration script: evolve-tx-off.

-- evolve-tx-off
create database evolveshared

while runnig above script getting an error that [dbname] is not exist. Evolve version is 3.0.0

Did you figure this out? Getting the same issue.

from evolve.