HOTSPOT
You are developing an ASP.NET MVC application. It is ready for deployment to the
production web server.
A local SQL Express .MDF file was used by the application during development
The deployment has the following requirements:
The deployment must merge the assemblies on the local machine with those on the host.
The deployment must publish the local database to the remote Microsoft SQL server.
You need to configure the web package settings for deployment.
Which settings should you use? (To answer, select the appropriate setting or settings in the
answer area.)
Explanation:
Hi there !
Answer to this question makes me problems. How could it be to say I take all files form a project folder (probably to take mdf file with) and also to say “Exclude files from App_Data” folder. That doesn’t make any sense for me. To deploy database to remote Sql Server you need “Include all databases configured…”
What do you say?
thanks
I think Exclude Files from the App_Folder should not be checked:
Select the Exclude files from the App_Data folder check box.
The project uses SQL Server Express .mdf files in the App_Data folders, but you will deploy it by running scripts in an empty destination database. Therefore, you will not deploy the .mdf files.
https://msdn.microsoft.com/en-us/library/dd483479(v=vs.100).aspx
All answers are correct.
CHECK Exclude files from the App_Data folder check box.
https://blogs.msdn.microsoft.com/webdev/2009/09/28/dev10-beta1-deploy-web-application-with-sql-express-mdf-file-to-hosts-sql-server/
I dont think this is correct, requirements said “must merge the assemblies on the local machine with those on the host”, in other words just an assembly is what deployment is all about => only files needed to run this app is what I would choose and exclude debug symbols same app_data.
Pre-build not needed as its not mentioned in requirements (this is only the best practice to do so).
Does it makes a sense?