Hi. This sounds great. Is this script one of the methods at http://requesttracker.wikia.com/wiki/MySQLToPg ?
/Johan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Emmanuel Lacour Sent: den 4 maj 2011 10:48 To: [email protected] Subject: Re: [rt-users] Manual for Full-text search 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
