Re: Porting SQL-scripts for Microsoft SQL-Server to Informix 7.

Posted in 1997

"Billy Wheeler" — 19 Feb 1997 02:08:06 -0500 — source: Informix-list mailing list archive (1991-1998)

On 18 Feb 97 at 14:05, Wellerding Andreas wrote: > I have to port a great number of SQL scripts written for the > Microsoft SQL-Server 6.5 to Informix database 7.2. Especially there > is a great number of stored procedures! Has anybody experience with > something else - or does anybody know a tool which could help me? We have done this exact thing. It was purely mechanical work, the SP languages are too different to write a porting tool, and you have to watch out for SQLServer's long column and table names. Informix's are only 18 characters long (the then-current ANSI standard). You are faced with a large re-write, I'm afraid. HTH. -- Ciao, Billy "...nod's as good as a wink to a blind bat..."