How do I migrate from SQL-Ledger?

A lot of people are wondering how to manage their migration to LedgerSMB from SQL-Ledger. While there is no one simple answer that will suit everyone's situation, there is some general advice.

First thing to know is - you are among friends. LedgerSMB is built on a community of people who want to see the software and it's users succeed. Information is freely shared, and as long as you are prepared to have a go at helping yourself, we are happy to jump right in and help you do that!

We now have a mailing list specifically for those still using SQL-Ledger - whether you are actively working on migrating to LedgerSMB or even if you are staying with SQL-Ledger for now and want some friendly community support, join up to the LedgerSMB SQL-Ledger Help List

This information is current as at April 14th 2007.

The best course of action depends on your situation:

I am running SQL-Ledger 2.8.0+

Short answer: roll-back to a backup or wait for LedgerSMB 1.3.0

Currently we don't have an automated migration path for installations of SQL-Ledger-2.8.0. We will have one when LedgerSMB 1.3.0 is released. We can however give (free) case-by-case assistance if you are stuck at 2.8.0 and want to move to LedgerSMB - it may be fairly straightforward for your case, we just can't guarantee it across the board yet.

If you can revert to an SL version prior to 2.8.0 without data loss (ie, you upgraded but haven't entered any new data and can restore your old version) then you can migrate most easily by reverting to your previous SL install, then following the advice below for users not yet on 2.8.0

If you have upgraded to SQL-Ledger 2.8.0 and have new transactions in it that are not in your old backup (or you don't have a prior backup) then your best bet is to wait until LedgerSMB 1.3.0 is released, or contact us on the lists or IRC channel for specific advice on the best way to migrate. We plan to have a direct migration path for 2.8.0 users once 1.3.0 is out.

I am running an older SQL-Ledger (pre-2.8.0)

Short answer: Jump in, the water's great

Excellent, this is right now the easiest migration path. Current recommendation is that you migrate to LedgerSMB 1.1.12 which includes some important security fixes and data integrity controls not found in any SQL-Ledger version, but if you want to jump straight up to 1.2 you have options there as well.

I want the easiest, quickest way to LedgerSMB

Short answer: Upgrade to LedgerSMB 1.1.12

The best way is to upgrade to the latest 1.1.x release (1.1.12 as of this writing). These releases contain fixes for some serious security flaws not fixed in any SQL-Ledger version and several improvements for data integrity. It is also a clean GPL'd release without any licensing concerns for translations, contributions etc.

From Chris Travers' list email April 14 2007:

The upgrade to 1.1.x should be as simple as any SQL-Ledger upgrade. However, we do tighten some of the integrity controls and occasionally people run into problems cases where the data in the db is in an inconsistant state. If you do, write for help or contact us on #irc and we can help you sort through it.

Note that currently the upgrade from 1.1.x to the 1.2.x series involves some changes to user authentication and template variables which might require some manual intervention for some installs. This migration path might be smoothed out a bit as time goes by, so if you are feeling cautious, stay with 1.1.x until you are comfortable with moving to 1.2.x or directly 1.3.x.

However, if you want to get the pain out of the way, or just want to be running the latest and greatest...

I want the latest, shiniest LedgerSMB

Short answer: Great! Go straight for LedgerSMB 1.2.x

From Chris Travers' list email April 14 2007:

The upgrade from 1.1.x to 1.2.x is a little rough. We have made a number of changes, which although they are again good security design, break a lot of backwards compatability. These include:
1) User information is stored in the database (we have a script to migrate users)
2) No server writeable and executable perl scripts ;-)

Remember, you might have some small issues with migrating from anything up to 1.2.x currently. That's OK though - there is plenty of expedient help available and most of the hiccups are easily fixed up. Try the mailing list, or for rapid-response support try the IRC channel - there are usually a few members from the core team online to help you out of any migration issue you might have.

Comments

b2bec21.com

Timberland boots selected the wear,indeformable of the double pure leather,soak in a special waterproof wax in long time.to 70 percent of water absorbed into the wax,then to th outer leather of the silica treatment,while the inner layer to use calf,with a unique microporous thermal structure.with warmth and ventilation,branch of shoes body with glass fiber shank bone structure ,then in order to protect the stability of human walking and support force,formaing one body with the sole
After the old master will handle the entire waterproof leather and according to the boots model to make, the leather from the sole part of the package,they are made in accordance,then by the old master skill for many years advanced the shoes make raw rubber shoes leather shoe blade fixed.
Timberland boots have their unique resistance to pull,by using four solid braided rope combination of each other,thus adds to its sturdy,pull resistant features,even if the shoes does not wear a little.
In addition,the shoelace hole is unique with rust,when in the humid environment,even the whole pair of shoes is in the water,it will not be submerged in danger of rusting.
Good taste, exquisite craft---timberland boots

weoGytPigC

DpyegwPzcLdUTExvrr

Yes, really great

Yes, really great article!

How to Get Rid of Acne

nice blog

Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here
My Blogpost : Wisata Semarang : News : Travelling : Used Stationary Bikes : Used Stationary Bikes : Used Stationary Bikes : Indonesia Furniture Handicraft Wholesale Marketplace : My Blogpost : Seo Services : Indonesia Furniture Handicraft Wholesale Marketplace : My Blogpost : Eiknujomorp : Wisata Dieng

authorizedugg

Why UGG called ugg snow boots,what is ugg?
Ugg began popular in suring enthusiasts,due to the sheepskin can keep warmth and comfortable,so the ugg boots were accepted by more people gradually,and it was become to necessary appliance in winter.beacause the sheepshin boot is used in heavy snow area of North america,and people bengan to forget that ugg boots only can keep warmth gradually,and after that,ugg snow boots this name bacame pronoun of ugg brand.
If want to talk about the ugg boots history,we will back to last century 30’s,Australian farmers’s foot often feel cold after doing labour,especially in winter.then they began to use sheepskin boots to keep warth,and that is ugg boots origin.,at that time, sheepskin boots was called ugg boots by Australian,after that was used by air service.due to flew in high sky,foot can be keeped warth is the big problem with air service,so the sheepskin boots was became the neccssary appliance for pilot.then the sheepskin boots has another name,that is flying-ugg and ugly boots..
in 1994,ugg Australia trademark was registered by an American,and the manufacturer has changed,from Australian to chineses.
If you want to know more about ugg brand,pls click here”ugg brand”,then I can tell you more and more.

b2bec21

The timberland shoes has high commitment about its products,the social responsibility (CSR) of timberland company is based on values,define our society:human beings,humilitypursuit of excellence.for 30 years,"community"has been equated with the desire to share the service ethic of our forces common interests.
Establish and maintain a strong community,including sitizen participation,environmental management and global human rights.
Calendar year transtition,timberland's corporate social responsibility team are from four different business units,to be unificatin ministry,led to the current capacity,priorities and stratagix choice.due to this year's process is a coherent strategy,a clear social and environmental objectives.
Through greater stakeholders understanding and cooperation,we intend to prove the value of reform promote the consumption of out community and regional goals.
In 2010,we launch our new long-tem CSR strategy and focuses on four strategic objectives,or "pillars".each pillar of support,several key initiatives closes to long-tem quantitative targets,and get through rigorous review process of involving stakeholders.
In the future timbelrland boots will be more brilliant

buyuggboots

Now everyone knows ugg snow boots,but how many do know about ugg boots brand,.
Next I will share with ugg boots brand knowledge brand for you.,actually,i It is not only products brand,but also it is genericterms for one kinds of shoes.
Normally,UGG called ugg snow boots. it is grow up in the world war.
Australia two pilots used two sheepskin to pack for shoes,and wear in foot to get warm,and then that is popular in Australia gradually.
And the original name is ugly shoes,later the Australia called ugg boots,until 1994 that is registered trademark by american,so ugg is the American brand, and the manufacturer is by Asustralia to chinese.
Ugg boots was to create high quality and luxury,comformatable wearing environment for consumers,let more and more consumers share with their comfortable and fashion life.

b2bec21

The timberland shoes has high commitment about its products,the social responsibility (CSR) of timberland company is based on values,define our society:human beings,humilitypursuit of excellence.for 30 years,"community"has been equated with the desire to share the service ethic of our forces common interests.
Establish and maintain a strong community,including sitizen participation,environmental management and global human rights.
Calendar year transtition,timberland's corporate social responsibility team are from four different business units,to be unificatin ministry,led to the current capacity,priorities and stratagix choice.due to this year's process is a coherent strategy,a clear social and environmental objectives.
Through greater stakeholders understanding and cooperation,we intend to prove the value of reform promote the consumption of out community and regional goals.
In 2010,we launch our new long-tem CSR strategy and focuses on four strategic objectives,or "pillars".each pillar of support,several key initiatives closes to long-tem quantitative targets,and get through rigorous review process of involving stakeholders.
In the future timbelrland boots will be more brilliant

authorizedugg

Why UGG called ugg snow boots,what is ugg?
Ugg began popular in suring enthusiasts,due to the sheepskin can keep warmth and comfortable,so the ugg boots were accepted by more people gradually,and it was become to necessary appliance in winter.beacause the sheepshin boot is used in heavy snow area of North america,and people bengan to forget that ugg boots only can keep warmth gradually,and after that,ugg snow boots this name bacame pronoun of ugg brand.
If want to talk about the ugg boots history,we will back to last century 30’s,Australian farmers’s foot often feel cold after doing labour,especially in winter.then they began to use sheepskin boots to keep warth,and that is ugg boots origin.,at that time, sheepskin boots was called ugg boots by Australian,after that was used by air service.due to flew in high sky,foot can be keeped warth is the big problem with air service,so the sheepskin boots was became the neccssary appliance for pilot.then the sheepskin boots has another name,that is flying-ugg and ugly boots..
in 1994,ugg Australia trademark was registered by an American,and the manufacturer has changed,from Australian to chineses.
If you want to know more about ugg brand,pls click here”ugg brand”,then I can tell you more and more.

ec21b2c

I love nike air max shoes, I have 8 pairs of nike air max shoes.
There are nike air max 92,air max95,air max 360,air max 87,air max 90,air max 2010,air max TN,air max 180.
Nike air max shoes is so comfortable,it give me surprise,I am pround with my nike air max shoes.
Nike air max shoe is the best in the athletics shoes,the high quality meterial and unique design ,make nike air max shoes always in hot selling.
Every year,Nike company could introduce new style and durable nike air max.that shoes are so suitable for you,when wearing Nike air max shoes,that is easy for you to relaxe yourself in sports.
I am glad to share comfor and fashion with you,nike air max shoes showsthe sports spirit,you will be more confident with nike air max shoes.
In the market,now it is hard for you to select the suitable shoes,due to reason,the price,quality, new style and so on.pls believe me ,the nike air max shoes is the good choice for you,the best gift for you.
If you shopping online,you can order the cheap price but the same quality nike air max shoes.

ec21b2c

I love nike air max shoes, I have 8 pairs of nike air max shoes.
There are nike air max 92,air max95,air max 360,air max 87,air max 90,air max 2010,air max TN,air max 180.
Nike air max shoes is so comfortable,it give me surprise,I am pround with my nike air max shoes.
Nike air max shoe is the best in the athletics shoes,the high quality meterial and unique design ,make nike air max shoes always in hot selling.
Every year,Nike company could introduce new style and durable nike air max.that shoes are so suitable for you,when wearing Nike air max shoes,that is easy for you to relaxe yourself in sports.
I am glad to share comfor and fashion with you,nike air max shoes showsthe sports spirit,you will be more confident with nike air max shoes.
In the market,now it is hard for you to select the suitable shoes,due to reason,the price,quality, new style and so on.pls believe me ,the nike air max shoes is the good choice for you,the best gift for you.
If you shopping online,you can order the cheap price but the same quality nike air max shoes.

northfaces

It is possible for you to get the cheap north face jacket online.
Cheap north face jacket are hot selling on the webstore.
Do you know how to order cheap and discounts north face jacket?
That is question for some people.
Due to high quality ,unique style,in north face jacket shoppe,the price is so expensive,normally it is hard for some people to accept this high price.even they love north face jacket so much.
north face jacket sales online,you can order cheap shoes and get the same quality like jacket shoppe.
But still some people are afraid with shopping online,about quality,and safe.
Friend,I can offer the good news to you,pls do not worry about them. I have shopping online several times,that is safe for you to order som goods online.
When you shopping webstore,about payment method,you need to choose paypal,as you know paypal can protect our money well,normally before you get the order,paypal can not release the payment to seller.if you meet any question about your order,you can writer the state to paypal,I think it will deal with it well for you.
About the quality,I suggest you to visit the good webstore,it can offer high quality north face jacket and high quality service,cheap price.
You can have a try to shopping online,I believe you will happy with your orders.
If you want to know more north face jacket sales online,pls click here “north face jacket”.

I wonder if you have an

I wonder if you have an update on the knee. Like you I have been suffering from knee pain for a few years now. It can be very frustrating. I will try some of the suggestions in this document. Thanks in Kindy Web Design Houston.

gIOQgKFdsBeW

SXjlBKckrvf

Such an effective way. tempe

Such an effective way.
tempe pest control

MwEabfmxJqLRYKGip

dtxPmxoOHCCx

cDiEeVOVwgIy

prednisone vflsi tramadol tjk valium online 48349 tramadol 353086

ehwtAZRGwRHeUKsaZXm

hUkdBJAoEeNNwI

FdOVYAhUCF

AnTUJyTQcDG

Vbf2J7 kwcfsgeiyeox, [url=http://medmavfqlgwe.com/]medmavfqlgwe[/url], [link=http://qdmgywprpaji.com/]qdmgywprpaji[/link], http://nzyzrjwsggjv.com/

roGdHlXSpFala

XjWDxaRRDCGxP

google

BecoRUpgLEsVKtvevg

jOjIreDvzwhYYFelVeQ

viagra %-))

KgPegOlYRrOLvzh

hi

so if you are feeling cautious, stay with 1.1.x until you are comfortable with moving to 1.2.x or directly 1.3.x.Insurance

BUNohKDMqIzcHt

SCkklcXgnqdI

lSeHfcQJso

mgsClxkbDhiUBPPgIg

accutane buy 281 cialis 032313 xanax valium 8-P cialis 8-D xanax ptouem

XfhtHQXWyFpVKlLmxj

GNIeMdOwZGD

TrhyhtsRsBLfQCv

rWBPMmITuTLOU

ambien driving aitnzz xanax =-( viagra 6028 cialis jfvt

iMgfhEghJlyZSt

8h0LhX wefhiwixzyqi, [url=http://woubabowweyl.com/]woubabowweyl[/url], [link=http://iaerzbupvwmj.com/]iaerzbupvwmj[/link], http://mmiscncnaqaa.com/

RvjJuLqfudtbtfs

BZtmrNrcXTr

buy accutane okqcp acomplia vgvoz phentermine >:-OOO acomplia 870861

MKFiSBuHIYeXZTB

TDmqUNISNZjXGawHhfD

ambien =PP prednisone rnjind accutane 1923

LwnLYYAYOqCRXrxv