Inserting from MS SQL Server to MySQL database
If you want to do this regulary
- LinkedServer and
OPENQUERYcould be good, if you are moving not too much records per cycle.
- Integration Services Package is a good solution if you want to move lots of data (like thousands or millions of rows).
You can schedule them with SQL Server Agent.
INSERT is a bit tricky with
INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table')SELECT * FROM dbo.SQLServer_Table
INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table')VALUES ('Value1', 'Value2', ...)