Deploying ASP.NET 5 application with backing DB on client servers -

i'm writing asp.net 5 application targetting .net core using ef7. when i'm done, i'd publish application platform-specific installer that, when run, install service, deploy database based on user-input credentials sql server. service self-host asp.net application.

is possible? how go achieving this?

thanks!

we use msdeploy @ work deploy of our components: web applications, windows services, scheduled task, sql databases, etc.

you use following command package service code:

msdeploy -verb:sync -source:dirpath=/path/to/service -dest:package=servicepackage.zip -verbose 

and command deploy target:

msdeploy -verb:sync -source:package=/path/to/service -dest:package=servicepackage.zip -verbose 

use database project sql database , create dacpac publish. can use msdeploy publish dacpac:

msdeploy –verb: msdeploy-verb –source:dbsqlpackage="db.dacpac"[,dbsqlpackage-source-parameters] –dest:dpsqlpackage="targetconnectionstring"[,dbsqlpackage-target-parameters] 

finally use manifests wrap single msdeploy package.

regarding user input values database, use webdeploy parameterization files define variables , apply them database deployment. these parameterization files can used non-web deployments via msdeploy. write powershell wrap msdeploy command deployment prompt user inputs , edit setparameters file.