[typo] Migrating from SQLite3->PostgreSQL

Steve Lenti stevelenti at 3pop.com
Mon Jul 16 17:45:21 EDT 2007

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.

On 7/16/07, Mitch Pirtle <mitch at spacemonkeylabs.com> 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
> Typo-list at rubyforge.org
> http://rubyforge.org/mailman/listinfo/typo-list

More information about the Typo-list mailing list