I have one Informix in OpenVMS machine and another MS SQL in Windows machine. I cannot touch the Informix server at all.
How to do the extract/update the data periodically from Informix to SQL? I was thinking of writing a service. But I don't know how to do the incremental update.
I was thinking of doing a pull subscription from MS SQL. Is it feasible? Is it a replication or integration service? I dunno. Please help.
Thank you.You don't need to write a service. There already is a service. Use DTS.
I do a nightly tranfer of data from Informix to SQL Server for one of my steady clients.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment