HOWTO: Setup SQL Server Linked Server to MySQL

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Different Options for Importing Data into SQL Server

http://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/

Sample : 
Create LinkedServer:
EXEC master.dbo.sp_addlinkedserver @server='MYSQL', @srvproduct='MySQL',
@provider='MSDASQL', @provstr='DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=192.168.0.10;Port=3306;USER=root;PASSWORD=pollex123;OPTION=3;DATABASE=pollexsurvey';
Reseed:
DBCC CHECKIDENT ( pls_respondentdetail_extsat
, RESEED, 830);
DBCC CHECKIDENT ( pls_respondentdetail_extsat
, NORESEED);
Select Query:
SELECT * FROM OPENQUERY(pollexsurvey,
'SELECT * FROM pls_question')
Select INTO:
SELECT * INTO internalSat.dbo.pls_question FROM OPENQUERY(MYSQL,
'SELECT * FROM pls_question')
Insert Query:
INSERT OPENQUERY(MYSQL,'SELECT * FROM contact') SELECT * FROM contact

Update query:
UPDATE OPENQUERY(MYSQL,'select fax from contact where id=482') SET fax='123456'
Delete Query
DELETE OPENQUERY(mysql,'select fax from contact where id=482')