migrate informix db on mssql server 2005

hi, i should migrate one informix db on a mssql server 2005, any ideas how this goes short and efficient? second problem, also stored procedures must migrate von informix db to mssql server 2005, is there a way? one more question, where does informix store the stored procedures on the sco - unix machine? thx thx grizzel -- grizzel ------------------------------------------------------------------------ grizzel's Profile: http://unixadmintalk.com/1424 View this thread: http://unixadmintalk.com/showthread.php?t=267496

On Mar 16, 5:47 am, grizzel <helmut.ha...@gmx.net> wrote: > hi, > > i should migrate one informix db on a mssql server 2005, > > any ideas how this goes short and efficient? > > second problem, also stored procedures must migrate von informix db to > mssql server 2005, is there a way? > > one more question, where does informix store the stored procedures on > the sco - unix machine? > > thx thx > > grizzel > > -- > grizzel > ------------------------------------------------------------------------ > grizzel's Profile:http://unixadmintalk.com/1424 > View this thread:http://unixadmintalk.com/showthread.php?t=2674 You can get the info from looking up or downloading and reading the documentation on stored procedures and triggers. We have a SCO 5 machine with an older informix (5 ). Basically, It stores them in sysprocbody . It may not work on your system but here is a sql that shows content of stored procedures. select * from sysprocbody where datakey = "T" order by procid, seqno it will show the proc id and procedure code.