We have got an export utility inbuilt with MSSQL 2005 version (Earlier version also having this functionality). Using this utility you can easily transfer table data from one DB to another. On the other hand, if you want to do it pro grammatically then, what you need to do is to create and instance of your mysql server and another instance of your mssql server. Now start reading all the data from MSSQL, put it in a datatable and then when all the rows are finished reading, start transferring them to the instance created of the MySQL table one by one, column by column. Remember that select statement needs to be run for both MySQL and MSSQl table in the start, so as the the table instance are same for both the table during data transfer.