Re: Converting from Informix till SQL-server, Experiences ?

Posted in 1996

Mike Lemon — Mon, 14 Oct 1996 14:19:09 GMT — source: Informix-list mailing list archive (1991-1998)

Nils.Myklebust@idg.no (Nils Myklebust) wrote: >mdl@interpath.com (Mike Lemon) wrote: >:Indeed. I'm afraid that this disparity in functionality is one of the >:reasons we are also considering strongly considering a move to MS ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Whoops! >:SQL-Server. Informix's great weakness is their castrated SPL--at >:least compared to SQL-Server. It is truly unfortunate, as they have a >:very powerful engine. >Well, it does also have Visual Basic Enterprice Edition, Delphi, >Powerbuilder and so on. So the situation isn't all that bad. And >Informix also have NewEra. >However the original poster and Mike Lemon should look at the >Universal Server before they even consider changing to SQL server. >Universal server will have SPL that goes outside everything you have >seen so far, including (but not limited to) Java executed inside the >engine. >Also all the other new facilities and functions in Universal Server >will be so revolutionising you that any move to SQL Server will seem >like a move to the stone age. >This all assumes Informix can pull it off though, but there seems to >be every reason to believe that. Are there any preview papers covering this topic? I don't remember seeing them on the Informix site, but I really wasn't looking for it, either. The one truly unfortunate characteristic of MS SQL Server is Microslut's unrelenting promotion of Visual Basic. Billy Boy's love affair with this tired old hag really sickens me. We use the MS Office apps heavily here, and the integration with SQL Server is far better than with other engines--as one would expect. This integration, though, is VB based, which really disgusts me. We would love to use some OLE Automation functionality (which I am just learning about) to provide transaction services, but the easiest method I know of to write these modules is in VB4.0. Arrrgh! What I've seen of Delphi looks very nice, but again, their love affair with Pascal rivals MS with VB. Mike Lemon mdl@interpath.com