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

Posted in 1996

Mike Lemon — Fri, 11 Oct 1996 14:18:33 GMT — source: Informix-list mailing list archive (1991-1998)

billy@west.co.za (Billy Wheeler) wrote: >> Has anyone had any experience of converting a database >> from Informix 5 to SQL-server. >We went the other way. We had a lot of problems because SQL server allows >longer table names, etc. So your conversion should be easier, but do be aware >that the stored procedure and trigger languages vary completely. Indeed. I'm afraid that this disparity in functionality is one of the reasons we are also considering strongly considering a move to MS 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. Mike Lemon mdl@interpath.com