Click here to Skip to main content
13,093,720 members (60,228 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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 3-May-13 16:31pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 4 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100