Search code examples
javaquartz-scheduler

Copying the data from MS SQL server to MySQL

I need to copy all the data from MS SQL server to MySQL server. I am planning to use the Quartz scheduler to perform this. This scheduler will run every night and move the data from MS-SQL-Server to MySQL server. Can anyone please tell if this is fine or is there any other better way to do this?

Update:
I need to transfer only one table with 40 columns (from MS SQL server to MySQL)

Solution

  • I wouldn't involve java unless I absolutely had to: java would be adding no value but would be adding extra complexity.

    This is a "DBA" type task that belongs in a script scheduled with cron tab.

    If I was implementing it, I would export the source database as an SQL script then import it by running it on the target.