How to generate SQL file from ASP.NET Web app during publish?

Question

I have a ASP.NET Web application, which serves as a backend web api for my Android application.

Now just for development purpose, I am using SmarterAsp.net's free trial hosting. And I have successfully published the web app to the server using Visual Studio 2015 (CE) built in publish tool.

However I now need to setup the MS SQL database on the server as well, which requires SQL files to run from.

How would I generate the SQL files that are needed for my project? I am using Entity Framework and used Code First Migration that automatically setup my local SQL Server.

It would be preferable if there is a way to do this in VS without having to open up SQL Server and export the sql files. Thanks!

Steve Greene · Accepted Answer · 2016-05-19 12:56:13Z

3

You can do that easily with code first migrations. If you already have migrations enabled, just go to the package manager console and create an idempotent script:

Update-Database -Script -SourceMigration: $InitialDatabase

This will create a script of all your database objects. If you don't have migrations enabled, then it is fairly easy to configure from the console:

Enable-Migrations
Add-Migration InitialSnapshot -IgnoreChanges
Update-Database -Script -SourceMigration: $InitialDatabase

https://msdn.microsoft.com/en-us/data/jj591621.aspx?f=255&MSPPError=-2147217396#enabling

answered May 19, 2016 at 12:56

Steve Greene

12.4k2 gold badges36 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

How to generate SQL file from ASP.NET Web app during publish?

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