informix | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


i want to retrieve the informix data and put it into a text file. how i going to do this???
Check out linked servers in BOL. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterst�tze PASS Deutschland e.V.
… and can take help from DTS to connect to informix and choose destination to text file. fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
You can also use informix unload sql statetment. Google on informix unleashed keywords.
what i going to do is retrieve the informix data and put inside the text file. then the MySQL database will get the data from the text file and save it. how to do this whole process
So it does not have anything to do with microsoft sql server, this site is about. For informix side, you can use informix unload sql statement to generate pipe delimited text file. I have no idea how to import such file into mySQL database, better ask that question on mySQL dedicated forum.
Assuming that MySQL is a typo, you might want to check<a target="_blank" href=></a> as a good resource for DTS questions. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Heute schon gebloggt?<a target="_blank" href=></a><br />Ich unterst�tze PASS Deutschland e.V. <a target="_blank" href=></a>)