We are using an ASP.NET Core 6 web service which is connected with a local database. The web services are hosted on the machines of our customers as a windows service. The database is also on the same customer machine.
Now every time we upgrade the version of the backend, we have to connect to their machines to upgrade the version. This is sometimes very inefficient because with every update we have to get an appointment for a remote session to update the backend.
Now I am searching for a way to upgrade the backend automatically every time we release a new version of our web service. What are common ways to achieve this task?
I thought about a another web service which checks for new updates and manages the installation of the web service.