Convert SAP SQL Anywhere 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 SAP SQL Anywhere. 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
• integer bigint
• long binary long varbinary
• long nvarchar long varchar
• nchar char (if precision <= 65000)
• nchar long varchar (if precision > 65000)
• nvarchar varchar (if precision <= 65000)
• nvarchar long varchar (if precision > 65000)
• smallint bigint
• tinyint bigint
• uniqueidentifier binary(16)
• unsigned bigint bigint
• unsigned int bigint
• unsigned smallint bigint
• unsigned tinyint bigint
• varbinary long varbinary (if precision > 65000)
• varchar long varchar (if precision > 65000)
• xml long varchar