Hi,
I have successfully created an install and update which installs a Windows PC program (plus pre-requisites) as well as updates over a SQL database keeping customer specific data entered into certain tables.
As expected this install / update is a fairly large file (due to pre-requisites).
I am now looking at creating an automatic update process (similar to the one by advanced Installer) which is predominantly a MS SQL data update. The MS SQL has data that can be updated on a weekly basis and I need to get this out to customers PC's.
I cannot replace the MS SQL database since there will be user data in some tables and I am looking a keeping the size of the update as small as possible (hence do not want to send out full database).
I am using bcp to help add data into temp SQL table and then run a user program as a Custom Action which will transfer data from temp tables to live tables. bcp works successfully in current install / update.
When I now create an update install, "with only the files changed as part of the latest version", the update process removes all required files since I do not want to have these defined in the update since they have not changed.
Question 1). Is there a way in the update to NOT have to define all files that the program needs and ONLY define the files that have changed?
ALSO
Was looking at using Requirements | Launch Conditions | Custom - ProductVersion >= "2.1.0.1" to force this update to have a specific version installed first. This check fails all the time and the update does not start - even thought version 2.1.0.1 is installed.
Question 2) is there some addition help on using Custom \ Launch Conditions.
I MAY have to update the main program and some dll's (and other files) at a later date.
Thanks,
Brian