SAP IQ (known also as Sybase IQ or Sybase IQ) is a columnar, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

SAP IQ bases its performance on columnar data engine, like many competing solutions.

Full Convert supports SAP IQ database directly.

SAP IQ data types we support


bigint, int (integer), smallint, tinyint, unsigned bigint, unsigned int


decimal (numeric), double, float, money, real, smallmoney


char, long varchar (clob, text), varchar


binary, bit, varbinary


date, time, timestamp (datetime, smalldatetime)

Large objects

long binary (blob, image), long varchar (clob, text)



Export SAP IQ database

It may make sense to migrate your data away from SAP IQ. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current SAP IQ database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.