Sunday, December 7, 2008

Moving files from Windows to Unix

While moving files from windows to unix, we use several softwares like FTPclient, WinSCP3 etc. We may use binary mode to move the files from windows to unix. When we want to run a sql query file (*.sql) in Unix and the file has been transferred from windows to unix, make sure that you are running the following commands after copying the file.

DosToUnix "myQuery.sql"

This will prevent the junk characters which we can find inside the copied sql file.