Re: SL 2.8 to LedgerSMB 1.2

[Chris Travers <..hidden..>]

On Wed, Mar 17, 2010 at 6:17 PM, Luke <..hidden..> wrote:
> I would not be interested in paying you to do it (well, I probably would,
> if I had money to use for such a thing), but any tips you might have for
> the process would be greatly appreciated--I still have years of historical
> data in SQL-Ledger, that we are going to want out some day, probably next
> year.

The goal here wasn't just to advertise the services but to provide a
framework of how this was done for other consultants to use too.  A
rising tide floats all boats.  Obviously this assumes you have a
pretty good idea that LedgerSMB 1.2 will work for you.

The first part was to move the defaults data over.

alter table defaults add column setting_key text, value text;
alter table defaults add column setting_key text;
alter table defaults add column value text;
update defaults set setting_key = fldname, value = fldvalue;
alter table defaults drop fldname;
alter table defaults drop fldvalue;

I then ran pg_central.sql on the database.

I then renamed vendor and customer to old_*
I created new customer/vendor/transactions tables

The key here then was to populate the customer/vendor tables, this was
not too bad.  It just involves insert/select against the old_* and
address tables.

I then copied and pasted relevant portions of each of the upgrade
scripts and applied all the sql/fixes/scripts.

The other things that I had to do was run the upgrade_templates.pl and
import_members.pl against appropriate targets.

I found out later I had to add "notes" fields on the invoice and
orderitems tables.

I also had to adjust users_conf database values appropriately (dbuser,
dbpasswd, etc) but these might not have been necessary if I was not
moving it to another server, and re-configuring the whole thing at the
same time.

I haven't automated this process, though.

Best Wishes,
Chris Travers