Where should the upg.tps be located in the case of a SQL file server installation?
Seeing that there is no common data directory – I’d go with putting in the appdata directory (for Vista compliancy). What is quite a common tack is to run a conversion application on installing (which would probably be done on a central location – fileserver or the like) – this upgrades all the datafiles on installation, so that at runtime, each user is able to run their application without any upgrades required. The UPG file then becomes superfluous to each individual instance of the application.