[Pkg-sql-ledger-discussion] Re: dropping SQL-Ledger?

[Seneca Cunningham]

On Wed, Apr 18, 2007 at 07:50:07PM +0200, Raphael Hertzog wrote:
> Is there an upgrade path for sql-ledger user? I would like to switch over
> but my accounting data is something precious and I need to be able to
> import it and have confidence that it's still the same :-)
> 
> If there's none, how difficult would it be to create one from the database
> format that we have in the etch version of SQL-Ledger?

For SL->LSMB 1.1, it is renaming a config file and letting the ususal
SL database upgrade routines work.

For LSMB 1.1->LSMB 1.2, the process is a bit more involved.  Full
documentation is in LSMB's UPGRADE file, but an overview is:

  1) Backup (using a real backup system like pg_dump)
  2) Install required packages
  3) Manually run database upgrade scripts in sql/legacy 
  4) Setup auth db (may be same as main)
  5) Import user config
  6) Upgrade templates
  7) Write ledgersmb.conf

(yes, upgrade.pl is still a TODO)

-- 
Seneca
tentra at gmail.com