Share via

New Video: How Do I Deploy a Visual Studio LightSwitch Application?

  • Article

A new video was just released on the Developer Center video page:

How Do I: Deploy a Visual Studio LightSwitch Application?

I originally did this one for Beta 1 but now this updated with the latest Beta 2 release. In this video you will learn about what deployment options you have for a LightSwitch Application and why you should choose one over the other. I show you how to set up your database and deploy a 2-tier application as well as how to set up and deploy a 3-tier application onto a web server running Internet Information Services (IIS).

Also check out the following walkthroughs for more information on deployment:

I’ve been busy travelling and speaking at conferences but I managed to get this one done. :-) And I just got my Azure account set up (YAY!) so I’ll be planning on doing one on deploying to Azure next (once I get back from DevDays).

Enjoy!

Comments

  • Anonymous
    April 21, 2011
    Nice video... well done. One small comment would be that using Trusted DB connection for two tier isn't harder to maintain. You can grant access to a Windows domain group and have IT manage what users are in that group. This would be more secure than using a shared SQL username/password. I hope the username/password is encrypted on the clients config file? Question... how do you publish an upgrade or version 2 that has database schema changes? Does the publish wizard use and of DataDudes change management or create change scripts? Can you point me to how this will work? Thanks, BOb

  • Anonymous
    April 21, 2011
    Hi BOb, Point taken on the integrated security but in a two-tier situation I'd argure that the business doesn't have an IT department at all. In the case I showed, LightSwitch can set everything up for you. Yes the wizard can generate change scripts or update the database directly. On the Database configuration page of the publish wizard you indicate whether you want to create a new database or update an existing one. Cheers, -Beth

  • Anonymous
    September 09, 2011
    The excerpt below is from your tutorial on LightSwitch Deployment referencing IIS 7, "you should be able to open a browser to http://localhost and see the IIS 7 logo. If that doesn’t happen something got hosed in your install and you should troubleshoot that in the IIS forums or the LightSwitch forums" Troubleshooting this issue with the Forums has not resolved the issue that I have, I believe I have performed all of the required steps to make IIS7 to work properly e.g. display Local Host page.  A IIS 7 tutorial for LigntSwitch would be nice to have, or if there is a current one, I have not been able to find it on MSDN. Please advise - thanks.

  • Anonymous
    September 13, 2011
    @Scott -- I wrote up a deployment guide here: blogs.msdn.com/.../deployment-guide-how-to-configure-a-web-server-to-host-lightswitch-applications.aspx Do you have a link to your forum thread?

  • Anonymous
    July 24, 2014
    visual studio lightswitch 2013 an application is not deploy on iis7 (use sql server 2014) error is C:Program FilesMSBuildMicrosoftVisualStudioLightSwitchv4.5Publishv2.2Microsoft.LightSwitch.Publish.targets(1565,9): error : An exception occurred when deploying the database for the application. Could not deploy package. <Target Name="DeploySchema"            Condition=" '$(ExecuteSchemaDeploy)' == 'true' ">        <DeploySchema ConnectionString="$(PublishConnectionString)"                      IncludeSecurityDBObjects="true"                      ServerArtifactsFolder="$(_ServerArtifactsFolder)"                      Collation="$(DatabaseCollation)"                      IntrinsicDacPackageFilePath="$(_IntrinsicDacPackageFilePath)"                      DatabaseProject="@(_DatabaseProjectItem)"                      Inputs="@(ServerMetadataFiles)"                      ProjectPath="$(MSBuildProjectFullPath)"/>        <CreateSqlUser ConnectionString="$(PublishConnectionString)"                       UserName="$(SqlUserName)"                       AuthenticationType="$(AuthenticationType)"                       Condition=" '$(CreateSqlUser)' == 'true' and '$(SqlUserName)' != 'sa' " />    </Target> plz help..................

  • Anonymous
    December 10, 2014
    Trying to publish database to a SQL server 2008 R2 Database, it is a 2 tier deployment. whatever approach i am using "Directly publish" or "generating SQL script" it is giving me below error respectively: For direct Publish: ------ Build started: Project: CAFelatte.Server, Configuration: Release Any CPU ------  CAFelatte.Server -> C:Usersasriva4DesktopHydra CAF ProjectE2 PublishCAFelatteCAFelatteCAFelatte.ServerbinReleaseApplication.Server.dll ------ Build started: Project: CAFelatte.DesktopClient, Configuration: Release Any CPU ------  CAFelatte.DesktopClient -> C:Usersasriva4DesktopHydra CAF ProjectE2 PublishCAFelatteCAFelatteCAFelatte.DesktopClientBinReleaseCAFelatte.DesktopClient.dll  Begin application manifest generation  Application manifest generation completed successfully ------ Build started: Project: CAFelatte, Configuration: Release Any CPU ------ ------ Publish started: Project: CAFelatte, Configuration: Release Any CPU ------       Not signing the Xap file. C:Program Files (x86)MSBuildMicrosoftVisualStudioLightSwitchv4.5Publishv2.2Microsoft.LightSwitch.Publish.targets(1565,9): error : An exception occurred when deploying the database for the application. An error occurred during deployment plan generation. Deployment cannot continue. Done building project "CAFelatte.lsxtproj" -- FAILED. Build FAILED. ========== Build: 3 succeeded, 0 failed, 0 up-to-date, 0 skipped ========== ========== Publish: 0 succeeded, 1 failed, 0 skipped ==========

for generating SQL script: ------ Build started: Project: CAFelatte, Configuration: Release Any CPU ------ ------ Publish started: Project: CAFelatte, Configuration: Release Any CPU ------       Not signing the Xap file. C:Program Files (x86)MSBuildMicrosoftVisualStudioLightSwitchv4.5Publishv2.2Microsoft.LightSwitch.Publish.targets(634,9): error : An exception occurred when building the database for the application. An error occurred during deployment plan generation. Deployment cannot continue. Done building project "CAFelatte.lsxtproj" -- FAILED. Build FAILED. ========== Build: 1 succeeded, 0 failed, 2 up-to-date, 0 skipped ========== ========== Publish: 0 succeeded, 1 failed, 0 skipped ==========