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.

[c_baker]

Have you looked at PowerDesigner?

It can reverse-engineer SQLA databases and forward engineer the schema into IQ. You would still need to unload the data for re-loading into IQ or access the SQLA database as a remote database from IQ to load the data directly.

Chris

[former_member232292]

Hi, Chirs,

Thanks for your reply.

Yes, At first, I checked with customer if they have PD to reverse-engineering this ASA, and found they don't have it... As we know -- PD is not a free software. And if we ask customer to purchase a PD just for this migration, that's sound weird. :)That's why I'm asking if there's some tool like iqunload ... And if there's some guide for DB migration for BO from ASA to IQ? That would be more helpful.

Thanks

Regards

Eisen

[RolandKramer]

Hello eisen.wang

eisen.wangSAP SQL Anywhere is the SQL Interface for the SAP IQ Database.

Hence, either IQ or SQL Anywhere should have export/import features to exchange the data

Did you find anything on the Blog - SAP (Sybase) IQ – the hidden treasure …

Best Regards Roland

[former_member232292]

Hi Roland,

Thanks for your reply.

Yes, I know ASA is the meta-data store for IQ -- that .db and .log file for IQ. But this time -- customer is requesting migration their BO's ASA to IQ. So only export/load table is not enough. I need something like iqunload to export not only data but also the schema and DDL in the source ASA. But I can't find it. Do you know any tool or guide for this purpose?

Thanks

Regards

Eisen

[chris_keating]

BO does not list SAP IQ as supported for the CMS and Audit repositories. Please refer to the PAM Essential Information.

For supported platforms, there is a BO KBA for migrating 1899321 - Moving or Copying or Migrate CMS database to a new Database / Schema / Instance / Server u....

As an aside, DBUNLOAD command line tool and the SQL Central Unload Database functionality is similar (or equivalent) to iqunload.