Re: Comparative between DB2, Informix and Oracle

DA Morgan wrote: > Serge Rielau wrote: > >> DA Morgan wrote: >> >>> Depends. If an internal applications I'd give a different answer from >>> it being an externally accessible app. It depends on security, >>> scalability, application server, etc. >>> >>> What you are asking is the equivalent to which database is the best. >>> Without including information about "for what". >> >> >> I wish that were true. In my experience the question about migrating >> from one product to another is governed by one overriding factor: >> Price of migration. >> >> Cheers >> Serge > > > Perhaps I missed something somewhere. I thought you were an internal > coder for IBM? How many migrations have you been involved in where you > were part of the decision making process (as opposed to part of the > implementation team)? Let's just say my day to day work is not limited to compiling DB2, swearing at clearcase and posting in newsgroups. ;-) > Price of migration is one of many factors. But only one and generally > the tool chosen is an insignificant part of that cost. The biggest cost > is is the time spent as payroll dollars. And that is hardly ever about > the tool itself. Possibly for the first time ever we agree: The cost is in the payroll dollars. Therefore the degree of automation is a crucial factor. Migration is an investment with an associated risk. Both increase with the amount of redesign and manual labour. It needs either a big pay-off or a seriously pissed of customer to make the investment and risk worthwhile. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab