Re: SQL server VS Informix

On 22 Aug 1996, Richard Spitz wrote: > Mak Siu Kei (siumk@b1.hkstar.com) wrote: > : Who could tell me whether Sql server or Informix is better ? > > This cannot be answered so simply. It all depends on your requirements > and the price you are willing to pay for it. SQL server on NT is > certainly cheaper, but will probably not scale as well as Informix does > on an UNIX platform. Also, SQL server lacks row level locking. FWIW, the latest MSpropaganda claims that V6.5 (current or very nearly so) does do row level locking. > : A stubborn consultant has come to our company and starts to promote Clipper > : DBF files as database. And again starts to promote the SQL server on NT. > > Yuck! What century does this consultant live in? DBF files are certainly > not state-of-the-art as database engine, especially when client-server- > architecture is required. SQL server on NT, on the other hand, is not bad > product per se. I'll agree with this. > : We are currently running Informix 7.11 on RS6000, and is forced to change to > : NT with SQL server running on a dual P5. > > What forces you to change. Informix 7.11 is a very modern product that > should be able so serve all your needs. If you absolutely MUST change > your server platform to Intel/NT, there is an Informix port to NT! If everything is working and you're not expecting a big increase in usage, I certainly wouldnt convert just for the hell of it. On the other hand, if your RS60000 is out of gas you *may* find that to upgrade the RS6000 and add informix seats may cost more than a NT server and SQL server. Joe Matuscak Rohrer Corporation 717 Seville Road Wadsworth, Ohio 44281 (330)335-1541 Matuscak@Rohrer.com