[ACCEPTED]-Inserting from MS SQL Server to MySQL database-sql-server

Accepted answer

Score: 20

If you want to do this regulary

LinkedServer and OPENQUERY could 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 1 them with SQL Server Agent.

The INSERT is a bit tricky with OPENQUERY:

INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table')
SELECT * FROM dbo.SQLServer_Table

OR

INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table')
VALUES ('Value1', 'Value2', ...)

Source: stackoverflow.com

More Related questions

Should I add this new column to customers table or to a separate new table?

check date between two dates or NULL in sql

What is the MS SQL Server capability similar to the MySQL FIELD() function?

SQL SUM values where 2 conditions are met

Why in SQL NULL can't match with NULL?

How to hide password to MySQL database from people using the program

Adding characters in values in an existing column

Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server

Adding A Column that doesn't exist in a query

How do I add a total as the last row in my sql?

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.