EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Problem with ENUM Migrate from MySQL  XML

Forum Index » Tuning and Migration Wizard
Author Message
xjrmame

Member

Joined: 2 Feb 2011 18:37:11
Messages: 20
Offline

Hello
I have installed the newest PostgreSQL and also the migration wizard which is included in the package.
Problems occured while converting my MySQL tables which have ENUM types?

But why?
I thougt that Postgre now supports ENUM?

regards
Tom
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

PostgreSQL does support ENUM. However, way of using it different following link would help you:

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
tomscho

New member

Joined: 6 Feb 2011 11:20:40
Messages: 1
Offline

Vibhor_K wrote:PostgreSQL does support ENUM. However, way of using it different following link would help you:


OK, but with the Migration Wizard I got errors while migrate from MySQL . Is this an problem of the Wizard?
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

For such tables, Manual work would be require.

Example is given below:


In Postgres Plus

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team