On Tue, 2007-04-24 at 19:12 -0700, Chris Travers wrote: > > If I convert my 2.6.x SL to 1.1.12 LS and I don't feel I have > > compelling reasons to go to 1.2 at this time, would I be converting down > > the road to a more stable 1.2 and then to 1.3? > > Yes. The database schema is not expected to change in any significant > way before 1.3 I was just about to suggest that from what I had seen here, that the best migration path that is manageable by LSMB in terms of scripting logic, sounded like "always go to LSMB 1.1.12". Details are:
1. SL to a stable LSMB. SL versions 2.6.12 thru to 2.6.27 -> LSMB 1.1.12. All those SL versions use 2.6.12 version database, so as far as data migration scripting goes, all are the same thing. This gets you from SL to LSMB. (I suppose I better start contributing: I shall migrate today. If I need to hack this migration I hope I shall be able to script the result and submit it here.) - If you have an earlier version of SL, upgrade first to SL 2.6.12, then migrate over to LSMB, as per the preceding. - If you have SL 2.8.x (currently just 2.8.1) there is NO migration yet, but if you are on 2.8.1 already you are probably a cutting edge hacker, so please hack the SL 2.6.12 to LSMB 1.1.12 script and submit it into here. :-) 2. LSMB 1.1.12 to the latest (may be unstable) LSMB. Upgrade LSMB via the normal LSMB upgrade scripts (SQL + ??). Hopefully 1.2.4 is stable. If any further scripting (eg shell) is needed to upgrade cleanly from 1.1.12 to 1.2.4 maybe this should be the only new functionality to go into a 1.2.5 release, ie to get to a stable 1.2. > > Or would there be a > > migration path of 1.1.12 to 1.3 directly? > > I think that this may be possible as well. In the past, with SL at least, one could jump through several releases in one step by installing the latest release, and running whichever set of Pg-Upgrade....sql scripts related to your old and new releases. I assume that this remains the case with LSMB. (I do not recall any discussion lately to indicate contrary.) Chris, please let me/us know if I need to be looking at any other upgrade hacks (shell commands that ought to be scripted, and I shall look again at them.) Finally, I appreciate the fully positive discussion lately. That's a great sign, and bodes well for the project. Flames and personal attacks might easily have crept in, and often do on many other sites. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
