How can I generate DDL scripts from Entity Framework 4.3 Code-First Model?

Question

I have a project I'm trying to deploy and I'm using a cheap host to get started. As part of the hosting package I have a SQL Server database, but I don't have drop or create privileges, I can only use the database they've created for me. Being that's the case, I want to get the DDL so I can run it manually.

I'm aware I could script the database create scripts from SQL Management Studio, and that may ultimately work fine, but I'd like to automate the process as much as possible, so if I could get the scripts that Entity Framework creates, that would be ideal.

Diego Mijelshon · Accepted Answer · 2012-05-06 01:06:15Z

7

You can use the Entity Framework Power Tools.

I also wrote a tiny open source tool for that, EFScripter.

It takes two parameters: connection string (it can be as simple as "Integrated Security=SSPI" if you have a local instance of SQL Server), and the dll containing the DbContext.

It writes the script to the standard output.

answered May 6, 2012 at 1:06

Diego Mijelshon

52.7k16 gold badges119 silver badges159 bronze badges

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

Comments

Richard · Accepted Answer · 2012-05-06 18:59:49Z

3

You can generate the script using

Update-Database -Script

(from the Package Manager Console)

You can find further details in this walkthrough, which also describes some of the additional options you might need.

edited May 6, 2012 at 18:59

answered May 5, 2012 at 21:19

Richard

30.7k12 gold badges79 silver badges121 bronze badges

7 Comments

w.brian Over a year ago

Is this a command line tool? If you can elaborate enough that I can find how to execute this command, I will mark as answer.

Diego Mijelshon Over a year ago

It's a PS script... you can run it from the package management console.

Richard Over a year ago

Updated - as Diego says, this is run from the Nuget Console window.

Mr. Boy Over a year ago

@Richard this only seems to run if you have migrations (error:No migrations configuration type was found in the assembly)? Can you use it to get a raw dump of the whole DDL?

Richard Over a year ago

No, you need to enable migrations (Update-Database is the command to apply migrations).

|

Collectives™ on Stack Overflow

How can I generate DDL scripts from Entity Framework 4.3 Code-First Model?

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related