This might be a bit off-topic, but why are you considering migration? Any problems or some other reasons?
Sebastjan On 5/27/07, Jason McVetta <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---