On 09/29/09 21:05, Chris Travers wrote: >On Tue, Sep 29, 2009 at 7:52 PM, Joseph <[email protected]> wrote: > >> I've jumped from SQL-Ledger 2.2.7 to 2.6.27 in hope that I would be able to >> use most stable version 1.2.9 but uploading the sql-ledger database to >> ledgersmb >> is not the way to go I think as I got a lot of error messages and could no >> longer long in into ledgersmb. >> >> So, I deleted the database and reloaded a new one. >> I've notice that Ledgersmb does not change the last cost in the database >> upon ordering or changing the exchange rate, that is good. >> >> How to do upgrade? >> > >The upgrade scripts are in /sql/legacy/ in the LedgerSMB directory. > >Before you begin: select version from defaults; > >Then start with that version (Pg-upgrade-2.6.14-2.6.18.sql for example) and >run each script in sequence until you run out of them. This will bring it >up to speed. If a script errors out, ask for help here on this list. > >Best Wishes, >Chris Travers
Thanks for the input. So to be clear, I create an empty database load my sql-ledger data into it and start the upgrades, from my version forward, isn't it? These numbers are a bit confusing :-) My current version SQL-Ledger is 2.6.27 but when I save a backup it saves file as 2.6.12; so I should start loading the changes from 2.6.12 ? psql -U user my database < Pg-upgrade-2.6.12-2.6.17.sql etc. So the last two files are: Pg-upgrade-2.6.17-2.6.18.sql Pg-upgrade-2.6.18-2.6.19.sql What database version is LedgerSMB using? When I try to save it to a file it is showing 1.2.0 So I'm lost a bit where to start and where to finish? -- Joseph ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
