[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Considering move from SQL-Ledger to LedgerSMB
- Subject: Re: Considering move from SQL-Ledger to LedgerSMB
- From: "Doug Poland" <..hidden..>
- Date: Fri, 2 Mar 2007 10:35:46 -0600 (CST)
On Thu, Mar 01, 2007 at 10:37:43AM -0800, Chris Travers wrote:
> Doug Poland said:
>> I've been using SQL-Ledger for about a year and am currently
>> running 2.6.16 on PostgreSQL 8.1.4 to manage my small IT consulting
>> biz. As I've fallen several rev's behind SL, I'm considering
>> making the leap to LedgerSMB instead of the latest SL.
>> My question is, how far can I "fall behind" LSMB before a migration
>> from SL 2.6.16 to LSBM is impossible or very *painful*?
> The migration to 1.1.8 is designed to be no more painless than an
> upgrade of SQL-Ledger. 1.2 will be harder and we are working on
> migration issues at the moment.
Since I'm not in a big hurry to upgrade, would you say that I'll have
and upgrade path after 1.2 is released? As I am an Open Source
programmer/network admin, I'm capable and not afraid of rolling up my
sleeves. That said, this is one app I don't get paid to drive and
like it when it *just works*.
> There are two corner cases where you can run into problems, however:
> 1) If you have custom views, the change from DOUBLE to NUMERIC may
> cause the upgrade to fail. You will probably want to drop the views
> first, then recreate them later. pg_dump can be used to dump view
I didn't do any customizing
> 2) We are a lot more strict regarding data integrity than
> SQL-Ledger. There are a number of situations where data corruption in
> SQL-Ledger is allowed to slide and in these cases, the upgrade will
> fail. We can help you resolve these issues, however.
Thats hard for me to know and will cross that bridge if necessary :(
> My recommendation is to create a copy of your database and use that
> for the upgrade. Something like createdb -T sql-ledger ledger-smb
> will create a new database named ledger-smb as a copy of sql-ledger.
> Of course having other backups is a good idea for reasons other than
> the upgrade.
I don't do *anything* in SL without backups :) Thanks for your advice!