Is there a place where I can get some doc on the db schema so I can
convert the data myself?
On 07/06/2010 15:39, Derek Atkins wrote:
Hi,
Geert Janssens<janssens-ge...@telenet.be> writes:
On Saturday 5 June 2010, bdebrabant wrote:
Hi,
I am currently running gnucash 2.3.1 with postgresql backend.
When recently trying to upgrade to the latest release, I've faced a few
issues related to the db changes.
When launching gnucash after the upgrade, it recreated the db schema,
dumping the existing one (which I had to restore from backup).
One thing I've tried was to dump the data into an xml file. It failed,
due apparently to the amount of data.
Aren't the db changes supposed to be automatically applied to the
existing schema (new columns, date formatting) when upgrading?
If not, is there a tool to convert my current database?
You are using an unstable version of GnuCash. There is no guarantee on data
compatibility between unstable releases. So no, the db changes aren't
automatically applied.
If you say you tried to dump to xml, do you mean you tried to "Save as..."
from within GnuCash ? And that didn't work ? Can you open it with say 2.2.9 ?
Other than that, you could try to export to QIF and reimport that in a newer
version. Or perhaps Phill has got a better idea.
Oh, and if the data is important to you, please don't manipulate it with some
unstable software ;)
There were a bunch of SQL issues in the early 2.3.x releases. If you
were using 2.3.1 I'm afraid your data is locked in; there's no way to
upgrade, and I believe due to some of the issues there's no way to
extract it, either.
Sorry.
You'll have to start over.
Geert
-derek
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
