read this... http://scottstuff.net/blog/articles/2006/08/15/easy-backups-for-rails
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 7/16/07, Mitch Pirtle <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
