Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-30 Thread Malcolm Tredinnick
On Wed, 2007-05-30 at 22:48 +0200, Nicola Larosa wrote: > David wrote: > > The second reply asked "Why switch?" There's no smoking gun or nasty > > occurrence, but we're switching some applications from Oracle to open- > > source databases and are trying several. Because we need to interact > > bo

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-30 Thread Nicola Larosa
David wrote: > The second reply asked "Why switch?" There's no smoking gun or nasty > occurrence, but we're switching some applications from Oracle to open- > source databases and are trying several. Because we need to interact > both via Django applications and via direct SQL, we have been findin

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-29 Thread hotani
I've done this with a massive database. It wasn't pretty, but is possible. Here are my very brief notes on the conversion. I used phpMyAdmin to export the data, and the postgresql module in Webmin or phpPgAdmin. Webmin became necessary for large tables as phpPgAdmin would fail/ timeout or whateve

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-29 Thread Forest Bond
On Tue, May 29, 2007 at 08:46:29AM -0700, Joshua D. Drake wrote: > Well, that would be because MySQL is effectively broke in many weird > ways. Your best bet is to recreate your model in postgresql, initialize > that model and move the data over relation by relation. Where "broke" means roughly

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-29 Thread Joshua D. Drake
Hancock, David (DHANCOCK) 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

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Malcolm Tredinnick
On Sat, 2007-05-26 at 19:36 -0700, David wrote: > My apologies. I am using 0.96, not an SVN checkout of recent vintage. > I'll check out the two tickets mentioned (starting with 3324), and > search tickets first from now on. You don't have to apologise for asking questions. I was hoping to point

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread David
My apologies. I am using 0.96, not an SVN checkout of recent vintage. I'll check out the two tickets mentioned (starting with 3324), and search tickets first from now on. On May 26, 9:46 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Sat, 2007-05-26 at 18:02 -0700, David wrote: > > I have

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Malcolm Tredinnick
On Sat, 2007-05-26 at 18:02 -0700, David wrote: > I haven't got a lot to go on, output-wise; here's what I ran: > > [EMAIL PROTECTED] intl]$ python manage.py dumpdata fuel > > fuel.tmp > Unable to serialize database: Decimal("0.00") is not JSON serializable To repeat Russell's question: which ve

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread David
I haven't got a lot to go on, output-wise; here's what I ran: [EMAIL PROTECTED] intl]$ python manage.py dumpdata fuel > fuel.tmp Unable to serialize database: Decimal("0.00") is not JSON serializable And trying a different format, a different error: [EMAIL PROTECTED] intl]$ python manage.py dum

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Malcolm Tredinnick
On Sun, 2007-05-27 at 08:14 +0800, Russell Keith-Magee wrote: > On 5/27/07, Hancock, David (DHANCOCK) <[EMAIL PROTECTED]> wrote: > > > > 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: > ... > > manage.py dumpdata # chokes o

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Russell Keith-Magee
On 5/27/07, Hancock, David (DHANCOCK) <[EMAIL PROTECTED]> wrote: > > 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: ... > manage.py dumpdata # chokes on Decimal(0.00) datatype, not sure how to > load output anyway If this ap

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Sebastjan Trepca
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 fai

Re: OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Jason McVetta
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

OT: Resources for converting MySQL data to PostgreSQL for Django

2007-05-26 Thread Hancock, David (DHANCOCK)
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,