Importing data from ODBC to mySQL

sgtpepper

I am trying to transfer data from a mssql 7 database using ODBC into our sql server.

Any GUI windows tool (MS Access, etc..) that I use crashes (maybe because database has over 10,000 records?)

Can I use command line to transfer the data? I need to import the database from mssql7 to mysql server.

I am running mySQL on RedHat 8.0

Can you think of anyway I can easily makes these two databases talk to each other?

Bunkermaster

if it's just once, export as a txt data file and import using mysql features or develop a script to do so 🙂
If it's a recuring need, well... maybe make an excell macro that will extract data to txt data file etc...

sgtpepper

I am not sure it's that easy. What I would like to do is avoid using any widows programs all together. I would like to be able to (from my linux machine) somehow connect to the mssql ODBC server and input a specific table into my linux mysql server.

I want to try to do this all command line. Every windows program I try to use to pull the mssql data crashes!

Bunkermaster

install a localhost on windows and pull data from PHP then setup a way to pull data from apache windows localhost to linux

kenhess

Sorry about not wanting to use Windows but I use a product called DBTools from some guy in Brazil. The website is:
http://www.dbtools.com.br/EN

This tool is excellent. You can import from almost any source to MySQL or PostgreSQL.

This is the best of the tools I have found for doing stuff with MySQL. It will even go through a wizard with you and create some php pages for querying your db.

The tool is free and you can connect from your PC to remote MySQL Servers and import data to them from your local machine or from another computer....it is awesome and fairly intuitive to use. The author is also pretty helpful in fixing things that you bring to his attention.