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
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
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
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
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
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
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
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
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
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
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
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
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
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,
14 matches
Mail list logo