How to convert MySQL to Vertica

Making migration easy for you

Full Convert is a fully self-tuning software. Your migration will work as expected without you needing to adjust anything.

Data types are different in Vertica compared to the source MySQL. We automatically adjust them as we copy the tables so you don't have to worry about it. You can adjust the mapping rules if you wish to change the following defaults:

• bigint unsigned bigint
• bit boolean
• blob long varbinary
• char long varchar (if precision > 65000)
• datetime timestamp
• double double precision
• enum varchar(255)
• geography long varchar
• geometry long varchar
• int bigint
• int unsigned bigint
• json long varchar
• longblob long varbinary
• longtext long varchar
• mediumblob long varbinary
• mediumint bigint
• mediumint unsigned bigint
• mediumtext long varchar
• nchar char (if precision <= 65000)
• nchar long varchar (if precision > 65000)
• nvarchar varchar (if precision <= 65000)
• nvarchar long varchar (if precision > 65000)
• set varchar(255)
• smallint bigint
• smallint unsigned bigint
• text long varchar
• tinyblob long varbinary
• tinyint bigint
• tinyint unsigned bigint
• tinytext long varchar
• varbinary long varbinary (if precision > 65000)
• varchar long varchar (if precision > 65000)
• year bigint