On Tue, Oct 18, 2011 at 6:21 AM, Milan Babuskov <[email protected]> wrote:
> ** > > > Thomas Clarke wrote: > > It is broken down into two major parts, i) > > update the exe file based on version numbers and ii) update the Firebird > > database structure. > > You could also version your database and make the upgrade simple. > Database changes are often not just about metadata, but also data > transformations and there is no way to do that in ad-hoc manner. > Consider for example changing from timestamp column to store the same > data into varchar(50) column with added timezone string. This requires > something like: > > UPDATE mytable SET newcolumn = oldcolumn || ' default timezone'; > > Only way to apply such change to production database is to log it as > such. No database structure comparison tool would be able to handle this. > > > > Any ideas as to the best way to go about this? > > Log all your database changes and apply them in production. Some tools > like IBExpert and FlameRobin have options to do this automatically for you. > > See this paper for example implementation (demo source code included): > > > http://heanet.dl.sourceforge.net/sourceforge/fbexport/managing_metadata_fixed.zip > > -- > Milan Babuskov > > Thanks Milan, I have reached the same conclusion and that is to work with versions of the database structure and then create change scripts and use these for the updates. I will read your article a bit later today. Regards. Thomas Clarke. > ================================== > The easiest way to import XML, CSV > and textual files into Firebird: > http://www.guacosoft.com/xmlwizard > ================================== > > > -- Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: [email protected] web: http://cybersea.biz [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
