Hi All This is totally outside Delphi, but some of you may know the perfect solution.
We have applications which rely on a base set of data held in SQL tables for their operation. One example is that all user visible text (captions, messages, etc) are generated from the database. These tables are maintainable by the user to customise the look and feel, but the user can only maintain a descendent set, not the default values. When we distribute a new build of the applications to clients we need to : a. Update their schema. b. Update procedures, triggers and indexes. c. Update the default values in the "base data" tables. a. Is done through a manually maintained script that can update from any previous version based on a value stored in a "version" table. b. Is done through a automatically generated script that drops and recreates all objects other than tables. c. Is done through a script that compares each value to the current value and update/inserts as necessary. All of these are cumbersome and prone to finger trouble. Can anyone point me in the direction of a simple, safe and maintainable solution? TIA Stephen Disclaimer : This communication contains information that is confidential and the copyright of ensynergy Limited or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone ensynergy Limited on +64 9 3551591 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of ensynergy Limited. Any views expressed in this communication are those of the individual sender, except where the sender specifically states them to be the views of ensynergy Limited. Except as required by law, ensynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. _______________________________________________ Offtopic mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/offtopic
