Re: conversion of SP's from Informix to SQL server
Posted in 2005
Topics: Migration, Import/Export & Data Conversion
calyanram@hotmail.com said: > Hi, > > Is there any way to convert Informix Sps to SQL server by using any tool? > > or is it need to rewrite all the procs. Rewrite, baby! Just think of all that yummy figuring out what the procedure does, development, testing, redocumentation. Migration doesn't look so cheap now, does it? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list
Obbie is right.... most DB vendors and 3rd party vendors (like DBartisan and the like) don't pay attention to Informix.... so you're on your own unless perhaps sqlserver 2005 and it's improved DTS (now called SIS) can do it. "Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message news:1111754745.2506762f1f57cf144d1db8336ab0fac5@teranews... > > > calyanram@hotmail.com said: > > Hi, > > > > Is there any way to convert Informix Sps to SQL server by using any tool? > > > > or is it need to rewrite all the procs. > > Rewrite, baby! Just think of all that yummy figuring out what the > procedure does, development, testing, redocumentation. > > Migration doesn't look so cheap now, does it? > > -- > > Bye now, > Obnoxio > > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche > > "I'm trying to see things your way, but I can't get my head up my ass" > - JCH > > "Ogni uomo mi guarda come se fossi una testa di cazzo" > - Marco > > Travel broadens a person. You look as if you have been all over the world. > > I went to the airport to check in and they asked what I did because I > looked like a terrorist. I said I was a comedian. They said, "Say > something funny then." I told them I had just graduated from flying > school. > > -- Ahmed Ahmed > > http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg > sending to informix-list