Re: Informix .VS. Interbase

>On 22 Jul 1997, Allen Graetz wrote: > >} I'm curious as to what the differences are between Informix and a >} "middleweight" database like InterBase by Borland. What types of things >} can Informix do that some of the others can't? Interbase actually has some pretty cool stuff, like domains, which might cause some problems when migrating to Informix (I'm speculating only). Domains, for those that don't know, are an SQL92-ism (89-ism?) that let you say things like: DEPTNO is CHAR(3) and must be "HERE", "THERE" or "EVERYWHERE". Then when you create tables you can: CREATE TABLE employee(name CHAR(20), department DEPTNO) Interbase also lets you hook in your own custom routines into the engine something like a procedural version of datablades. Informix scales well, has excellent performance, and sophisticated data replication capabilities. Informix Universal Server also presents a pretty hot future with its OO integration. >} Also, how hard would it be to transfer data from a database such as >} IntreBase to Informix? The datapump that ships with many Borland products does a good job of this. Cheers, Kerry S ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.10 May 1997 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/