SQL Server support replicate between SQL Server and non-SQL Server Database.
U can choose snapshot replication ,transactional replicate and merge replication.
First U must establish a distributor(a SQL Server which is an agent is responsible for transfering data between two database server)
Then u will make SQL Server as a publisher and using the distributor u created to publish your data.
last, make the informix server as the subscriber to retrieve the data from the distributor.
Originally posted by Satya
Also refer to books online about replication, heterogeneous data sources topic.
I would like to use Access as the publisher and SQL as the subscriber. When I check BOL and forums... I am not finding anything that explains how I can accomplish this. Please keep in mind, I want to set up transactional replication between Access and SQL.