« Back to Training Forum

Informix to MS SQL

Combination View Flat View Tree View
Threads [ Previous | Next ]
Is there an easy way (a tool) to move data from Informix to MS SQL server in real time..... meaning, on call end call activity data gets inserted in Informix db, at the same time we want to insert same data into MS SQL server;

You can do that by doing an "end of call" processing where you can send the log data to MSSQL database. In CVP 4.0 and above you can use the logging API to build your own logger. CVP allows you to create and run multiple loggers in addition to or in place of default loggers. Your custom logger can push the log data out to MSSQL. As a matter of fact - the log data being pushed out to the Informix reporting server uses a custom logger that was built using the logging API.