By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,526 Members | 2,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,526 IT Pros & Developers. It's quick & easy.

update from between database

P: n/a
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
Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
DTS

"Thomas" <cf***@telamon-corp.com> wrote in message
news:84**************************@posting.google.c om...
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

Nov 17 '05 #2

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

--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net
"Thomas" <cf***@telamon-corp.com> wrote in message
news:84**************************@posting.google.c om...
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

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.