i wan't to know that if i write all the data in another data into text file and then i want to read from the text file and save the database in another database. how i have to write this program to read data from the text file and save the data into another database
hope anyone here can give some opinion or giv some light to me thank you
Your post is confusing. What exactly are you charged with doing? If it is simply parsing a file and inserting data into a database, there are plenty of tools that can do what without any programming. What makes you think that you need to use Java?
thanks vishwanath nadimpally you posting really will help me.
what i want to say is, i want to transform the data from the informix database to the MySql database. for do this i need to retrieve the data from the informix database and write into the text file with the seperator(|) and line break (/n). what i need to do is to write the java program that can read the data from the text file and put back the data in the mysql database, that's my case.
So any opinion and comment or suggestion, please...please... enlighten me.
Do you *have to* do the intermediate step of storing the data in a file? Why not select the data from the first database and immediately insert it into the second database? This would avoid the fiddly bits of parsing.
i mean is it can transfer directly the data from 1st database to the second database without passing in to the text file? coz my 1st database is informix and the 2nd database is MySQL, both is different database.