Check out Kettle (aka Pentaho Data Integration) from http://kettle.pentaho.org. It's a heavy-weight tool, but it has a fairly intuitive GUI and decent documentation. It's Open, of course, and very multi-platform (I personally use it on Windoze, Solaris, and occasionally Linux).
The function you want is called "Copy Tables Wizard". Just used that last week to migrate one of my Django apps from MySQL to Postgres. It's pretty straightforward and hassle-free. On 5/26/07, Hancock, David (DHANCOCK) <[EMAIL PROTECTED]> wrote: > > We are strongly considering migrating from MySQL to PostgreSQL, but there > seem to be enough differences between the two that I'm pulling my hair out. > I know this is somewhat off-topic, but has anybody got some resources for > the conversion process? > > I'd love it to be as simple as a dump-and-restore, but so far, no silver > bullet has emerged. Things I've tried: > > mysqldump --compatible=postgresql # not so compatible > dump-db.py from djangosnippets.org # many data differences > hand-editing dumped SQL # too much work, nonexistent foreign key > values > manage.py dumpdata # chokes on Decimal(0.00) datatype, not sure how to > load output anyway > > Thanks in advance, and > Cheers! > -- > David Hancock | [EMAIL PROTECTED] > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
