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 <[EMAIL PROTECTED]> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
