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

mdl@interpath.com (Mike Lemon) wrote: :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. :>Yes, but then we have 4GL. SQL Server has .... MS Access? :-) 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. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org