SQL Server Performance Forum – Threads Archive

informix

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
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¯Â¿Â½tze PASS Deutschland e.V. http://www.sqlpass.de)

… and can take help from DTS to connect to informix and choose destination to text file.
http://msdn.microsoft.com/archive/en-us/dnarsql7/html/heterodata.asp fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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=http://www.sqldts.com>http://www.sqldts.com</a> as a good resource for DTS questions. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstÃ¯Â¿Â½tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

]]>