Re: Informix on NT?

I have used DTS to port. But that was from Sybase to MS Sql Server. Its pretty smart and efficient though. You should not have any problems. "Doug Baroter" <qwert12345@boxfrog.com> wrote in message news:fc254714.0308251811.6dbd84db@posting.google.com... > Art, thanks for the response. However, the statment > "You can export from Informix to flat files > and load the data into SQL Server if needed" is troublesome, well, how > does one maintain data structure, entity relations etc. system > schemas? Someone has suggested using MS DTS. Maybe that's a viable > option. Have you tried that approach? Thanks. > > > "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.08.25.16.34.00.592252.10594@bloomberg.net>... > > On Mon, 25 Aug 2003 16:20:12 -0400, Doug Baroter wrote: > > > > > I have a client who's using an MRP system from ROI System, and he said > > > it's Informix database and it's on NT. I have never heard of Informix > > > on NT, can Informix be on NT platform? If so, which version of Informix > > > and is it easy to export the db to another DBMS, say, MS SQL Server > > > 2000? And what would that take? > > > > > > Thanks. > > > > Yes IDS on WinXX is available it is the only OS that IDS runs on which is > > NOT a UNIX variant. IDS 7/8/9 are all available in their latest > > incarnations on that platform. You can export from Informix to flat files > > and load the data into SQL Server if needed, also IDS 9.xx can define > > external tables which can reside in other servers, then there's Informix > > Enterprise Gateway.... > > > > Art S. Kagel