How to use EF code first migration to generate scripts from powershell

Question

I have a need to email our DBA when a deployment, that utilizes EF6 code-based migrations, goes out. I am able to use the migrate.exe tool with the verbose flag, through powershell, to get the scripts but each command is truncated after 10222 characters. This usually only effects the model hash for the migrationHistory. Does anyone know of a way to generate the full sql script for EF6 migrations through Powershell

thanks T

Tarig · Accepted Answer · 2018-06-09 18:07:41Z

1

Figured out that migrate.exe is wrapping the toolingfacade class So I created the object passing in the required variables as well as setting the verbosedelegate. The nice thing about this is that I could run the updatescript function instead if I just wanted to get the sql scripts

[Reflection.Assembly]::LoadFrom("EntityFramework.dll") | Out-Null
$con = New-Object -TypeName System.Data.Entity.Infrastructure.DbConnectionInfo -ArgumentList @("constring", "System.Data.SqlClient")
$tools = New-Object -TypeName System.Data.Entity.Migrations.Design.ToolingFacade -ArgumentList @("dbcondllname", "dbcondllname",$null,"workingdr",$null,$null,$con)
$tools.LogVerboseDelegate = {param($sql)
    Write-Verbose $sql -verbose #dumps the sql to RM log
}
$tools.Update($null,$false)

edited Jun 9, 2018 at 18:07

answered Jul 11, 2016 at 17:10

Tarig

317 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

4c74356b41 Over a year ago

any change you can clarify what is dbcondllname?

Tarig Over a year ago

dbcondllname is the dll name that the db context residues in, I believe the second argument is where the migrations are stored which for this case was the same dll

Tarig Over a year ago

Here is the link to the class constructor for more clarity. ToolingFacade

Daniel Over a year ago

There is also $tools.ScriptUpdate. If you call Update it also applies the migration.

Collectives™ on Stack Overflow

How to use EF code first migration to generate scripts from powershell

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related