Convert Adaptive Server Enterprise 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 Adaptive Server Enterprise. 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:

• bit boolean
• char long varchar (if precision > 65000)
• datetime timestamp
• double double precision
• image long varbinary
• int bigint
• money decimal(19,4)
• smalldatetime timestamp
• smallint bigint
• smallmoney decimal(19,4)
• text long varchar
• timestamp bigint
• tinyint bigint
• ubigint bigint
• uint bigint
• unichar char (if precision <= 65000)
• unichar long varchar (if precision > 65000)
• unitext long varchar
• univarchar varchar (if precision <= 65000)
• univarchar long varchar (if precision > 65000)
• usmallint bigint
• varbinary long varbinary (if precision > 65000)
• varchar long varchar (if precision > 65000)