windows-1252?Q52=65=3A=52=65=70=6C=69=63=61=74=69=

You basically have six choices: - Use Informix Enterprise Gateway to access the SQL Server tables as if they are native and use triggers to replicate changes to the IDS tables in the SQL Server tables. - Use the Informix Virtual Table Interface to define the SQL Server tables as native and use triggers to replicate changes to the IDS tables in the SQL Server tables. - Periodically extract data from the tables and diff with the last extract to determine what to load into the SQL Server tables. - Create a set of UDRs in Java or C to insert/delete/update data to the SQL Server tables and call them from from the appropriate triggers on the Informix tables. - Create a set of UDRs in Java or C to log changes to the IDS tables to disk so that they can be replayed to SQL Server by an external task or service. - Purchase a third party universal replication product. Art S. Kagel ----- Original Message ----- From: Kurt Buffington <ids@iiug.org> To: ids@iiug.org At: 11/13 9:50:34 What is the most efficient way to synchronize/replicate from Informix (IDS 9.4 Solaris) to SQL Server? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.