Alternative Way to Import SQL to MYSQL

Question

Before, I asked a question in here how to linked the SQL to MYSQL. It was a success and I can also query from it. The problem is upon searching why "I can't find SQL SERVER AGENT" in SQL SERVER MANAGEMENT STUDIO EXPRESS EDITION is because it is "EXPRESS". All the ideas that I will be working using SQL Scheduler will unable to continue because the management studio that I have is not capable of it.

Can I have alternative way where in I can create scheduler or scheduled time for Transferring the SQL to MYSQL.

Thank you.

Answer 1

This solution could be of help. For scheduling, you'll have to do what is outlined here. You can connect to an Express instance using MySQL WorkBench as outlined here, but you can't schedule jobs.

Also, have you considered using ODBC to connect and send the data to another (i.e. MySQL) server. You can schedule many of these systems also!

Or try JDBC using SQuirreL SQL or DBeaver? Personally, I can recommend SQuirreL SQL! If you want to schedule a job using Java, try the solution here! Just be aware that your dumps may not be internally consistent unless you are careful about your transactions!

Answer 2

I would suggest Pentaho Data Integration, community edition. It is free and will suit your task perfectly. You will need JDBC drivers for both SQL Server and Mysql, and create a very simple transformation with a table input and a table output. You design and test your transformation in a tool called Spoon, then schedule a command line tool called Pan to run in.