Is it possible to generate db sql script with Ef4 CodeFirst on build?

Question

On build, I want to automatically create a sql script to generate a fresh database. I plan to use this script so I have can create a master database I can compare with the production database, to generate a migration script. I can't use my development DB, because I have it setup to use SqlCE during development.

Unfortunately, I can't seem to find anything in the CodeFirst API to generate a sql script. I'm sure it's possible, because model-first does it. I see the API calls on my DbContext to initialize a database, but nothing that gives me the script to actually initialize it myself.

I also want to have this script generated on build. What is the best way to have that occur? I was thinking to create a T4 template, and use Chirpy to have it run it on build, but I am wondering if there is a simpler solution.

Ladislav Mrnka · Accepted Answer · 2011-03-24 08:13:44Z

2

No there is no such possibility at the moment. In my opition it can be possible by creating custom initializer. The initializer will create the database and use SQL Server Management Objects to create scripts from the database. But it will only create scripts based on current database server so in case of SqlCE you will get scripts for SqlCE (there are differences in used SQL types).

The correct approach in your scenario is installing SQL Server Express edition and use standard features to initialize your database and that instance. Then you will be able either use create script from database or use Visual Studio 2010 database tools to create diff. scripts against your production.

answered Mar 24, 2011 at 8:13

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

1 Comment

KallDrexx Over a year ago

That's what I was afraid of. I guess the best route to go is to create a "Can Create Sql Express Database" unit test, and that way any time I run unit tests, it will recreate the database on the local machine's Sql Express. Thanks :)

Ricky Gummadi · Accepted Answer · 2012-02-21 20:59:26Z

2

For any one that's still looking;

one option is you could get generated DDL as a string and save it to to a file;

string sqlscript = (context as IObjectContextAdapter).ObjectContext.CreateDatabaseScript();

answered Feb 21, 2012 at 20:59

Ricky Gummadi

5,3502 gold badges50 silver badges70 bronze badges

Collectives™ on Stack Overflow

Is it possible to generate db sql script with Ef4 CodeFirst on build?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related