[rt-users] migrating from MySQL to Postgres?

[Thomas Sibley]

On 06/24/2011 04:34 PM, Dario Landazuri wrote:
> Just fyi, I've been playing around with the Migration Wizard
> EnterpriseDB has written.  I'm not done yet, there's still two small
> problems, but here's what I've found so far:
> 
> 1) The Wizard fails to migrate tables ScripActions and ScripConditions
> with the following error:
> 
> Error Creating Table ScripConditions:ERROR: type "varbinary" does not exist

If you look at etc/schema.Pg, the two columns that are varbinary in
etc/schema.mysql are varchar(255).

You probably want to check the Pg schema the migration wizard created
against the one RT expects and fix, or at least take note of, any
differences.

Thomas