-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.

Improve this question
2
  • 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. Commented Nov 19, 2016 at 16:53
  • Thanks a lot for the hint. Commented Nov 20, 2016 at 17:46

1 Answer 1

Reset to default
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.

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

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.