on 12-27-2017 5:59 PM
Hello All
we have a SAP NLS solution based on BW 7.4 (oracle) with Sybase IQ 16.1 and would like to migrate this complete solution from AIX to Linux (different endian formats). For SAP BW the instructions are quite clear (the R3load approach) .. but for Sybase IQ the documentation is not very straightforward. There were some recommendations in this link but is still not very clear as the instructions seem to indicate moving data at the table level - rather i am looking for instructions to migrate the entire SAP IQ database
Hi, I would also like to know more about point 2. It doesn't seem to be clear.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, thanks for the answer .. is there any document you could point me to that illustrates these steps. ? Also your point 2 is not clear.. do you have to export one table at a time and import one table at a time .. surely there must be a more simple solution possible
Thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I just completed 1 task very the same -- migrate IQ from AIX to Linux -- here's my steps --
1. Use iqunload -- to extract both DDL and DML from the source IQ -- and extract to NAS which connect to both AIX and Linux servers and both have read/write permission on it.
2. while exporting -- once completed 1 table -- then load table on the linux to import that table's data. -- here needs some shell control ...
...
After all data moved, shutdown the old AIX IQ server and rename the linux IQ server to original one.
HTH.
Regards
Eisen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.