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.

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 (AT) bloomberg (DOT) net> wrote

On Mon, 25 Aug 2003 22:11:52 -0400, Doug Baroter wrote:

Sorry, I misread yours. Thought you just wanted a way to get data in to
an MS SQL Server database or interoperate the two. Did not realize you
were seeking to port the entire database from IDS to SQL Server.
Unfortunately I avoid using MS products as much as I can get away with,
so I cannot help much more. I will tell you that you can use Visio to
reverse engineer the IDS schema and then should be able to import it into
SQL Server.

Art S. Kagel

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 (AT) boxfrog (DOT) com> wrote