poongkundran paranthagan wrote:
> how to migrate sqlserver to mysql
You might try using MS SQL DTS service to move data to an ODBC MySQL connection.
You might also use a program like
http://www.convert-in.com/mss2sql.htm
You could also write your own JDBC, ODBC, or DBI tool to do it for you.
Finally, if you can export the data as a CSV or tab delimited file, you can use MySQL mysqlimport command to import the data on a per table basis. The SQL Server BCP tool can be used to get a TAB delimited export that you can feed into mysqlimport.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting