I have a table in my mssql server that i need to move over to mysql. I dont even need all of the info, just 3 fields of the table. Any ideas of an easy way to export (from MSSQL) and import (into MYSQL)? Thanks!
I don't know much about MSSQL. But I think you can export data in text format from MSSQL. If this is true then you can use LOAD DATA INFILE to import data to MySQL.
You can use export from MSSQL to CSV file, and Import in MySQL Also you can use OLE DB connection, and make direct data transfer from MSSQL to MySQL
Use SQL Data Examiner 2010. The tool works with MSSQL, MySQL, Oracle... This tool is not free, but free 30-day trial is available
you can access to the specific table you want and make edit and copier , then go to the same place in your sql and coller ,, that's what i do