[Q] Database Connectivity, Informix/UNIX to MS SQLserver/NT
Posted in 1995
Topics: Connectivity: ODBC / JDBC / .NET
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. In the past, I have done something similar with INET & Q+E ODBC to link MS Access on Windows for Workgroups with the Informix back-end on UNIX. This was pretty cost effective (<$1000) for a single client, but not for 15-20 clients (some of which are on NT). I am now trying to make the link to Informix/UNIX with MS SQLserver on NT since my departmental databases are moving to SQLserver, and it is really easy for clients to query SQLserver (thru MS Access or MS Query) from Windows/Windows NT machines. Anyone have any pointers for DB connectivity tools or a reasonably painless solution to this problem? Thanks in advance!