[rt-users] Manual for Full-text search

[Emmanuel Lacour]

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