[IQUG] moving to IQ 15.x and beyond
jun.macalalad at hp.com
Thu May 30 01:42:35 MST 2013
Thanks all for your suggestions.
I've configured a IQ 15.4 instance and is in the process of using PowerDesigner. In the meantime, I've ran iqunload (schema and data) and are having issues with the 15.4 as it still uses the same iq space after migration. I was thinking of remapping the IQ dbspaces to bigger slices to optimize this DSS database.
I'll update you all as we go along.
From: Sipes, Sid [mailto:sid.sipes at sap.com]
Sent: Tuesday, 30 April 2013 9:40 PM
To: Macalalad, Jun; iqug at iqug.org
Subject: RE: moving to IQ 15.x and beyond
If you have the resources, it might be better to create a new instance of IQ 15.x, while leaving your 12.7 running.
You can then move the schema and data from the old server to the new server.
You can use PowerDesigner (download an eval copy if you don't have it) to move the schema.
And you can use extract/load or "insert-from-location" to move the actual data.
This will let you build an optimally configured 15.x.
SAP Americas, Inc
Director, Data Warehouse Solutions & HANA Platform
sid.sipes at sap.com<mailto:sid.sipes at sap.com>
Web Meeting URL: https://sap.na.pgiconnect.com/sidsipes
From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of Macalalad, Jun
Sent: Tuesday, April 30, 2013 5:11 AM
To: iqug at iqug.org<mailto:iqug at iqug.org>
Subject: [IQUG] moving to IQ 15.x and beyond
We have a project to move out of Sybase IQ 12.7 (ESD#4) to the near-latest version of Sybase IQ 15.4.
To move out of 12.7 ESD#4 will require ESD#5 (or later) to migrate the database to IQ 15.4. Coupled with this is the version of Windows Server platform supporting these versions.
I tried to query this last month but did not get any further. I also understand from Sybase/SAP that 12.7 ESD#5 won't even run on Windows Server 2003 R2 and that complicates the move to 15.4
Database Administrator - Sybase
Telephone +61 8 8464 2489 Fax +61 8 8464 2134
e-mail: mailto:jun.macalalad at hp.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IQUG