I've got a system I've written which has a 'client' front end and a 'server' back end. The back end sits on a standalone computer which is used purely for this type of thing.
I want to be able to create an update for the 'back end' but there are obvious problems in that I need physical access to the 'back end' to make changes. This presents an obvious logistical problem. I'd like to have a way to drop the back end file onto the machine and all data is pulled into the new version - an upgrade of sorts.
The only way I can see to do this is to write an import routine that connects to the 'old' back end and pulls all data across. I'd need to then rename the 'new' file so it replaced the 'old' file. This could cause so many issues.
Any ideas on the best route? I'm sure I'm not the only one who's thought about this