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.
on 2007-07-11 02:37
on 2007-07-16 23:18
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 2007-07-16 23:46
read this... http://scottstuff.net/blog/articles/2006/08/15/eas... 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
on 2007-07-17 05:12
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 ;-)