Re: Considering move from SQL-Ledger to LedgerSMB

["Chris Travers" <..hidden..>]

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.

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
definitions.

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.

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.

Best Wishes,
Chris Travers

On 3/1/07, Doug Poland <..hidden..> wrote:
> Hello,
>
> 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*?
>
>
> --
> Regards,
> Doug
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users