Hi,
today I uploaded on SVN trunk the new logic from migrating the existing
DBs from 1.1 format to 1.2. The strategy is different than in the
previous version.
The old "reinstall" proved to be suboptimal because of the lack of
flexibility and mainly it didn't provide a smooth transition (downtime
was required in order to swap the DBs, unsafe - data could be lost if
error occurred during reinstall - and data could be lost because of DB
changes).
A new approach was chosen this time - migration. A new DB is created in
parallel with the old one and data is processed and transferred into the
new DB via sql commands (and nor dumps), using strict mapping between
old and new columns. This way the original data is kept and complex
column renaming and data processing is possible (like lcr address for
example).
for the moment this migration is done only for mysql, but is possible to
do it for postgres also but as I'm not to much into, I will need some
help from some postgres guru ;).
in the mean while testing is welcomed ;)
regards,
bogdan