Re: Dumping large database

2010-06-14 Thread Jeff Green
Actually, upgrading to 1.2 and doing a copy from one db to the other seems like the best option. Thanks for the info Jeff On Mon, Jun 14, 2010 at 5:34 AM, David De La Harpe Golden < david.delaharpe.gol...@ichec.ie> wrote: > On 14/06/10 04:15, Jeff Green wrote: > >> I was wondering what would be

Re: Dumping large database

2010-06-14 Thread David De La Harpe Golden
On 14/06/10 04:15, Jeff Green wrote: I was wondering what would be the best method of trying to dump a large database. I am trying to migrate from postgresql to oracle, using django 1.2.1 I have been unsucessful in using dumpdata. One interesting point - django 1.2 supports multiple connections

Re: Dumping large database

2010-06-14 Thread creecode
Hello Jeff, I'm not familiar with postgresql but can you dump your data from postgresql similar to what can be done with MySQL and the mysqldump command? On Jun 13, 8:15 pm, Jeff Green wrote: > I would appreciate if anyone has suggestions on the best way to > migrate a large database. Toodle-l

Dumping large database

2010-06-13 Thread Jeff Green
I was wondering what would be the best method of trying to dump a large database. I am trying to migrate from postgresql to oracle, using django 1.2.1 I have been unsucessful in using dumpdata. It gives me a memory error. I saw one post to just try and using dump data into several fixtures. I tried