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

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. When we did the conversion from SQL-Server to Informix SPL, we not only reduced the code but the overheads as well. Informix-SPL may be a castrated version of Informix-4GL, but SQL-Server is a complete abortion. My advice is take a closer look before committing. ;-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+