On Wed, May 04, 2011 at 08:01:58AM +0000, Johan Sjöberg wrote: > I wanted to ask the same question, so I know if I should do the > migration before or after upgrading to RT 4. > There are a lot of different methods on that page, and the simplest > ones seem to be just dumping the MySQL database and importing it into > Postgres. Is there any general consensus regarding which method is > "best", with the biggest chance of getting non-corrupted attachments > etc.? >
I had success to do this using a script that select in source DB and insert in the destination DB (with a schema without datas). Test: Oracle->Pg, MySQL -> Pg to my knowledge and experience, this is the best way to do this. You can do this either: - 4.0 schema and datas -> 4.0 schema - 3.8 schema and datas -> 3.8 schema -> run 3.8->4.0 upgrades scripts