How to migrate IQ from power to intel x64

[Former Member]

Hello,

I want to migrate IQ (BW NLS) from power to intel x64.

Do you have any way to migrate?

I already checked this discussion.

This said that  copy data back to BW ,then copy data to new IQ(NLS).

     http://scn.sap.com/thread/3666308

This solution takes long time, so is there any way to copy data directly?

best regards,

Naritoshi Aoki, BeeX

[c_baker · Accepted solution]

I Would suggest following that advice.  BW explicitly knows of the NLS and has full control of the archiving process.

What you might want to do is add the new NLS as a second NLS to BW and then move the data a piece at a time under the control of BW.

Chris

[Former Member · Accepted solution]

Thank you Chris,

So copying through BW is the only way of NLS migration of NLS.

We're going to test this way.

Best regards,

Naritoshi Aoki

[Gisung]

Hi,

Here is a KBA in IQ's perspective that explains how to migrate IQ data to different format machine.

2102883 - SAP Sybase IQ: Moving Data Between Systems with Different Endian Formats

https://launchpad.support.sap.com/#/notes/2102883

Best Regards,

Gi-Sung Jang

[markmumy]

Keep in mind that this only applies to standalone IQ. As part of BW you must follow their procedure as it involves more than just loving NLS data.