How to migrate sqlanywhere to IQ?

[former_member232292]

Dear all,

One customer is checking with me -- how to migrate their current ASA to IQ as we know the IQ's syntax is same to ASA -- so he is thinking there must some fast/safe method to migrate so that there's no need manual re-coding.

But I can only search the guid of how to migrate ASA to ASE, can't find how to migrate ASA to IQ officially. Please kind advise.

Thanks advance for your help

Regards

Eisen

[RobertWaywell]

Migrating from SQL Anywhere to SAP IQ would be an unusual move because the 2 databases are built for very different use cases. Yes the SQL syntax will be mostly compatible, but there are some features of SQL Anywhere that are still handled by the SQL Anywhere layer in IQ such as stored procedures.

What is the current use case for the SQL Anywhere database?

SQL Anywhere is a row oriented database primarily used in OLTP scenarios with multiple concurrent connections modifying records in the same table at the same time.

SAP IQ is a column oriented database that is specifically used for OLAP scenarios where multiple concurrent connections can be executing complex analytic queries against data sets that can be multiple petabytes in size. A side effect of being a column oriented database is that SAP IQ is not suitable for OLTP workloads. By default only 1 connection can be writing to a given table at a given time. While the RLV store in SAP IQ does allow for concurrent writes it will not provide the same level of OLTP performance that SQL Anywhere provides.