On Wed, Mar 17, 2010 at 6:17 PM, Luke <account...@lists.tacticus.com> 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 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
