Re: Sybase isql converter

Posted in 1997

Peter Wiley — Tue, 30 Sep 1997 08:36:49 GMT — source: Informix-list mailing list archive (1991-1998)

In article <MPG.e9a0d06de18fea1989680@nntp.ix.netcom.com> mikem214@ix.netcom.com (Mike McCaslin) writes: >I have some Sybase SQL that I need to convert to run with DBaccess. Does >anyone know of a conversion program? 8 fingers, 2 thumbs, pair of eyes & a brain. Sorry, been a few years since I used Transact-SQL but IIRC, it was different enough in structure that it'd give problems. Maybe one of the CASE tool guys? I've been playing with ER/Studio and it'll happily reverse-engineer a schema pretty well (I translated an Oracle one to Informix) when I pointed it an an Informix one, it didn't seem to pick up the stored procs at all. Guess it depends how close your code is to ANSI 89. And if you've got user-defined data types anywhere, your next step is IUS or a lotta recoding. The joys of conversions. Have fun. Peter Wiley