Re: [Q] Database Connectivity, Informix/UNIX to MS SQLserver/NT

In article <3tvldg$ob2@news1.best.com> ron_ong@netpower.com (Ron Ong) wrote: > I am trying to share/transfer data between an Informix back-end on UNIX and > MS SQLserver on NT (sort of back-end to back-end). In particular, I am hoping > to set up a mirror of (or an attachment to) the Informix database on > MS SQLserver, or find a way to periodically (1-2 times a day) transfer > data from Informix to SQLserver. How about writing an ODBC based piece of code on the Windows NT Server to shuffle the data from the Informix/UNIX database to the Windows NT SQL Server? Another solution could be to migrate from Informix/UNIX to MS SQL Server 6.0 and use the new database replication features in SQL Server 6.0 to replicate the wanted data on the central SQL Server to the other SQL Servers. This solution requires no programming. If you want to check the new features in SQL Server 6.0, visit our Web server at http://www.microsoft.com. -- - Olav Tollefsen - Microsoft Norway - - Nothing I have written here is in any way, shape, or form official - Microsoft policy or opinion, and should not be represented as such - when quoted here or in any other forum.