EF Migrations Update-Database: Specify Script Name

Question

Before applying a migration in EF Code First, you can ask to see the SQL script it intends to apply with:

PM> update-database -script

Unfortunately this opens a script named something like tmp939D.sql in Visual Studio and then freezes the IDE until it finishes generating the script. If the script is long, this is a long freeze. Is there some way to push this to a file on the hard drive instead of in the IDE? A way to specify the name of the SQL script file it generates?

Community · Accepted Answer · 2017-05-23 10:24:48Z

1

See this answer for a solution: https://stackoverflow.com/a/14339379/219187

This solution does NOT use -Script, but takes a C# approach. We implemented it in a unit test, so our build server generates the SQL scripts after every software change.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Jan 17, 2013 at 15:12

theDmi

18.1k8 gold badges77 silver badges140 bronze badges

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

Collectives™ on Stack Overflow

EF Migrations Update-Database: Specify Script Name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related