Re: MS SQL/Server --- to --- Informix

>I have a mid-size Microsoft SQL Server database that I need to port over to >an Informix database. > >I don't know how to do this. Can anyone offer me assistance ? > >My exact scenario is this ... locally I'm using a SQL Server database, and I >also have a remote location that is using Informix. I would like to port >the SQL Server db over to Informix, and then send that once to the remote >client. > >Then, I would like to replicate the SQL Server db at my local server, and >then somehow just send the updates/replicated data to the remote location, >and then those changes/updates be applied to the Informix database. > >Is this possible ? Can anyone steer me in the right direction ? It doesn't sound like an easy job. Firstly, SQLServer allows things like longer table and column names than Informix. Secondly, the stored procedure languages are *very* different and require manual translation. Thirdly, a heterogenous replication product (such as Praxis OmniReplicator) is not cheap. In short, it is possible, but I'd rather pay someone else to do it. :-) It might be worth converting your local site to Informix at the same time. 8-> HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com