-4

I need to create some patch/update for existing ASP.NET MVC Legacy application: Update should:

  1. Stop IIS site
  2. Replace dll(s) and other content
  3. Update MS SQL database (add new columns to several tables)
  4. Start IIS site.

Need to do it on the production system and do not want to force customers to do it by hands. Also, do not know if Wix Installer should be appropriate choice (just 4 steps, and creation of Installer will take a lot).

Maybe some application exists which could help to automate such steps?

P.S: Migration of DataBase is not an option as well cause legacy system does not use EF. Application contains Inno-Setup installer which installs system from the scratch, but does not do for the update.

Alex
  • 842
  • 11
  • 33
  • Rather than stopping the site, 503 Service Unavailable would be more informative. You can add whatever human-readable text you wish. See top answers [here](http://stackoverflow.com/a/4916070/2226988). – Tom Blodget Nov 19 '16 at 16:53
  • Thanks a lot for the hint. – Alex Nov 20 '16 at 17:46

1 Answers1

1

I doubt any single application would cover your exact setup, preferences and requirements. Choose the best or most familiar tool for each step and script together yourself using powershell. Of course you could also use an installer to trigger or coordinate the steps but a simple script would usually be sufficient (and simpler at that).

To give you some more links to get started:

1) How can I stop and start individual websites in IIS using PowerShell?

2) Copy-Item powershell command

3) For DB use Visual Studio Database project to version your DB, export to DACPAC container and deploy using SqlPackage.exe

Also, once you have the script snippets it is trivial to include them in your automatic CI/CD tooling, for example Jenkins.

Community
  • 1
  • 1
Imre Pühvel
  • 4,468
  • 1
  • 34
  • 49