I have Typo 4.1.1, but I want to (temporarily) downgrade to Typo
4.0.3 for testing purposes. However, when I try to migrate the
database in the 4.0.3 web interface, it just gives me a Rails Error.
Is there any way to do this?
Thanks.
Hi everyone,
I’m new to Typo and have one site running in production mode, but with
SQLite3 as the database backend. Being the PostgreSQL fanboy that I
am, I’ve been looking for a nice way to migrate the data from SQLite3
to PostgreSQL.
However, I’m not finding much info - and what little I do have (rails
migrations, for example) won’t really cover the data.
Is there anyone on this list that has gone through this before? And if
so, is there a way to make this easier than a manual SQL debugging
session?
– Mitch
On Jul 16, 2007, at 17:45 , Steve Lenti wrote:
pretty much you do a backup and it saves your data to a .yaml file
then you change your database engine and do a restore. I haven’t
personally tested it but in theory it should work fine.
Thanks for the pointer Steve, that’s pretty handy to know…
However I think it’s safe to say it isn’t ready for PostgreSQL yet.
There’s no information for sequences, for example. So if you
“restore” a database with 50 tags into a clean PG-backed Typo, your
sequence still thinks it needs to start at 1. So your very first
INSERT (say, when you add a new tag record) goes boom. I’m willing
to manually adjust all sequences as there aren’t all that many, but…
Making things worse is the feedback table, which somehow has changed
despite me not consciously making any. I’ll try some db:migrate
voodoo and see how far that gets me.
And after that: Manual SQL it is, then!
– Mitch, setting off for a long, dull night of cut-n-paste 
read this…
pretty much you do a backup and it saves your data to a .yaml file
then you change your database engine and do a restore. I haven’t
personally tested it but in theory it should work fine.
-Steve