update from between database

[Thomas]

I have a Informix Database on Solaris and a SQL database. I need to
update from Informix to SQL daily. Is there any easy way of doing it?
BTW, I tried to use OleDbDataAdpater.Update to do the job. Nothing
happened after the program worked diligently for a while.

Thanks

 

[Jody Fisher]

DTS

 

[Steve C. Orr, MCSD]

I'd suggest using SQL Server Data Transformation Services (DTS)
Here's more info:
http://www.microsoft.com/sql/evaluation/features/datatran.asp