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

[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