Sybase IQ Implementation - # man-days
Can anyone tell me, number of man-days required to implement SAP IQ.
Mark Mumy replied
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.