Re: DB migration: Loading a massive fixture dump

2020-09-03 Thread Fred Blaise
Just for the follow-up, I ended up using pgloader and after some argument tweaking, it worked. Cheers. On Wednesday, September 2, 2020 at 7:26:04 AM UTC+2 Fred Blaise wrote: > Hi Mike, > > Thanks for the answer. > > Yes, I was aware yet hopeful regarding the size. > > Regar

Re: DB migration: Loading a massive fixture dump

2020-09-01 Thread Fred Blaise
Hi Mike, Thanks for the answer. Yes, I was aware yet hopeful regarding the size. Regarding the converter, I would be interested to take a look at your py3 work, if you could forward it along. Thanks. On Wed, Sep 2, 2020, 00:21 Fred Blaise wrote: > Hi, > > I have to migrate a data

DB migration: Loading a massive fixture dump

2020-09-01 Thread Fred Blaise
Hi, I have to migrate a database from mysql to postgresql. Unfortunately, there is quite a bit of data in there. As a strategy, I thought of using Django's ORM feature, dump the data from my setup using mysql, and load the fixtures on the other setup using postgresql, such as: # on mysql $ do