Drop and Create SQL Server database

[Obish]

Hi

i want to confirm if Evolve can drop or create a database in sql server

[lecaillon]

Yes, even if some reported issues I do not reproduce.

In the SQL Server integration tests of Evolve, you can see a database is created here, then a table in the new database here

Just use the special comment -- evolve-tx-off in the first line of your file, when you execute SQL Server commands that do not support transactions

[Obish]

Thank you for the response.

So what DB name should I specify in the connection string?

The one i'm about to create?

[lecaillon]

Do not add the database in your connection string or put master. Then in your scripts use the full name to identify your objects like in the scripts above.

By the way, the "standard" use of Evolve, don't recommend database creation scripts. Juste schema. But it is possible.

[lecaillon]

More information there : #97 (comment)

[pbparentpay]

Hi

i want to confirm if Evolve can drop or create a database in sql server

Has anyone tried to create the database? What needs to be connectionString? I am setting connectionString="Server=xxxx;Database=evolvedb;User Id=xxx;Password=xxxx;" and create database sql file as https://github.com/lecaillon/Evolve/blob/master/test/Evolve.Tests/Integration/SQLServer/Resources/Sql_Scripts/Migration/V3_1__create_database_evolvedb.sql
But I am getting error.
Evolve.EvolveException: 'Validation of the database connection failed. Cannot open database "evolvedb" requested by the login. The login failed.
But If I create database first in ms sql server manually, and just run create tables sql using Evolve, it's working.
What am I missing?
Platform: .Net Core 6
Db: MS SQL Server