Help... I have spent several hours on this and I cant figure out which way I need to go.
Situation I have a mysql 4.0 (Solaris 8) box that I am attempting to conenct to a MSSQL 2000 system (NOTE: I do not want to do this through php or VB I want to do it via command line) the mysql Dbase I have no problems being the admin and can do most tasks that I need to do. I understand that I need a client or a bridge to do the translation. I have tried installing the JDBC on Microsofts site and following these instructions (Microsofts site doenst tell you JACK) (http://www.akadia.com/services/sqlsrv_jdbc.html) but I also do not know java (I have been trying to set this up but I just can not seem to get it right)
I have been to http://www.unixodbc.org/ and installed the solaris package but I think that this is not the right thing. I have also added the mysql-connector-odbc-3.51.12-sun-solaris2.8-sparc-32bit.pkg package
Is there any step by step instructions on what I need to do???
That is the problem I am not sure which step to do first or even if I am looking at the right thing. Ideally I would think that there is a MSSQL client that connects to the MSSQL Dbase... From there I would extract the information that I need.. Via shell scripting change it to the format that I want it in for mysql and import it into mysql. Maybe I have this totally backwards??