Click here to Skip to main content
15,882,163 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I have a Win Forms app running on about 15 desktops. Users all have a Desktop shortcut to the myProgram.exe Updates involve going to each station and dropping the new exe on the station. App connects to a SQL server DB

What I would like to do is put the latest version of the app in a table in the DB, and a copy of the new version in a folder on the network somewhere and then use some sort of start-up app that checks the DB, and if the app is not the latest version, fetch the newest version of the exe from the server and run it. I dont want to have to rename the desktop shortcut, so would like to keep the myProgram.exe filename the same. I use a config file with the app for some user settings, so could put some info on the version in there, and update the config file each time a new versions is downloaded from the server?

I assume I need to write a new app to check the db, do the download (if needed) and then start the myProgram?

Can anyone offer some examples of the best way to do this?
Posted

Did you take a look at ClickOnce deployment? What you describe sounds like a good fit for a central deployment on a network share. Everytime the application starts it checks the network share for a newer version and updates the local copy if available.

Take a look here:
ClickOnce Security and Deployment[^]

However this is not driven by the database, but by updating the deployment on the network share.
 
Share this answer
 
There are most likely many ways to do this. You can place the new version(installer) on a server, where it can be downloaded with a small app for updating. The database is a great way to hold the version and the app can check this version. I typically set the app version same as update version that way the program can check it's version with the database - if it's not the same launch the updater app, download and run it.
 
Share this answer
 
Quote:
What you describe sounds like a good fit


That's a perfect fit! This could have saved me LOTS of trouble with Dot Net Frameworks etc :)

Thanks a Mil
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900