Sybase IQ Implementation - # man-days

[Former Member]

Hi All,

Can anyone tell me, number of man-days required to implement SAP IQ.
(Software implementation)

Thanks

[Former Member · Accepted solution]

Only rough estimation is required.

[markmumy · Accepted solution]

There are a couple of different pieces to consider in this.

The first area is infrastructure.  Prior to doing anything with IQ proper, we need to get the hardware in place and configured properly for IQ operations.  Assuming that there are no issues internal to getting hardware, the time could be as little as a few days, but more likely a few weeks.  Quite often, I find that the time spent in the hardware phase is all about educating the systems, network, and storage teams on how IQ works in the respective areas.  This is needed so that we don't have improperly configured hardware or hardware that was configured for IQ "because it is just a database".

Once the hardware configuration has been set, the time to actually implement IQ is quite small.  If we look at the installation, configuration, and database creation it should take just a few days to a week.

Once the database has been created, we need to look to the data model.  If we need to consider the porting of the model, that will vary depending on the model.  Most strict data model (tables, columns, indexes) can be ported in a few hours with a tool like SAP PowerDesigner.  More effort will have to taken for views and procedures as it is likely the porting of code from one database to another that will drive the timeline.

Mark

[Former Member · Accepted solution]

If multiplex, then it will take longer. 

Don't forget implementation of maintenance scripts such as backups, reindexing, etc. 

[former_member319447]

We are converting part of our ASE database over to IQ. 139 tables, 26 stored procedures. So far, the project has been going on for 4 months.

The problem is mostly on the ASE side, with bad data, mismatches in floating point values, and problems with the T-SQL when converted from ASE to IQ.

We are now getting to ready to install the Repserver (with realtime loading -RTL) to replicate data into IQ, so we'll see what happens next.