""Christian G. Warden"" <[EMAIL PROTECTED]> said:
> On Wed, Aug 25, 2004 at 06:30:04PM -0000, Aaron Stone wrote: >> ""Matthew T. O'Connor"" <matthew@zeut.net> said: >> >> > What might be helpful instead is a tool that is updated every time >> > someone makes a change to the schema of the database that verifies that >> > the user's schema is totally correct. Major problems will be obvious, >> > but missing unique indexes or wrong data types etc... will cause subtle >> > breakages. >> >> This is essentially the holy grail of database upgrade systems. Eventually >> we should include a 'dbmail-check' or 'dbmail-upgrade' (something like >> that) that reads out the schema, compares it to the release schema, and >> performs the necessary ALTER commands to get it up to date. >> >> To the best of my knowledge, no such tool exists :-\ > > mysqldiff and pgdiff should be useful. Both require fairly significant human parsing in order to generate reliable upgrades, don't they? Aaron --
