Insert into MySQL from SQL Server database

Asked Apr 13 '15 at 12:04

Active Apr 13 '15 at 12:06

Viewed 144 times

I have a data base which is SQL Server 2005, and I want to move some data from a table in this database to a MySQL database which is running on different server.

Is there any way to do this without using java code and creating some job.

SQL (Server A) Table1

Move To

MySql (Server B) Table2

edited Apr 13 '15 at 12:06

jarlh

42,561
8
45
63

asked Apr 13 '15 at 12:04

Rohitesh

1,514
7
28
51

This may start you in the right direction, but from what I read it's annoyingly non-trivial. http://stackoverflow.com/questions/5370970/how-to-create-linked-server-mysql – MatBailie Apr 13 '15 at 12:08
1

Try [MySQL Workbench](http://www.mysql.com/products/workbench/) and see [link](https://www.mysql.com/products/workbench/migrate/) – Gunaseelan Apr 13 '15 at 12:09
1

If your Java be handy, you could use JDBC to connect to both databases and do the transfer. This of course would require both drivers. – Tim Biegeleisen Apr 13 '15 at 12:11
See this [question](http://dba.stackexchange.com/questions/3153/need-to-migrate-sql-server-to-mysql) – Gunaseelan Apr 13 '15 at 12:13
Check this link. it might help.. https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html – Ambareesh Surendran Apr 13 '15 at 12:14
I want to create a JOB on(SQL Server) which will automatically runs and insert into mysql running on other server. – Rohitesh Apr 13 '15 at 12:31
2

You can do it with SSIS. – Tab Alleman Apr 13 '15 at 12:52
Rohitesh you need to Create a ssis package and create a SQL server Agent Job add your package in job and execute the Job . – Arun Gairola Apr 13 '15 at 13:01
Pentaho data integration (kettle) can also easily do that. It is free and opensource. – Dmitrij Kultasev Apr 13 '15 at 13:16
Tab Alleman thanks i'll try this – Rohitesh Apr 13 '15 at 19:30

Insert into MySQL from SQL Server database

0 Answers0