'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)

javaquartz-scheduler


Solution 1:[1]

SQL Server Management Studio's "Import Data" task (right-click on the DB name, then tasks) will do most of this for you. Run it from the database you want to copy the data into.

If the tables don't exist it will create them for you, but you'll probably have to recreate any indexes and such. If the tables do exist, it will append the new data by default but you can adjust that (edit mappings) so it will delete all existing data.

I use this all the time and it works fairly well.

by- david

Solution 2:[2]

I would recommend you to use http://www.talend.com for tasks like that.

UPDATE

Talend Open Studio for Data Integration is Opensource, there are some other features which are propietary details here

Solution 3:[3]

As PbxMan said, I would use an ETL, but I recommed Pentaho (http://wiki.pentaho.com/display/EAI/Spoon+User+Guide) which I think is far easier for such simple jobs

Solution 4:[4]

I agree with @bohemian - running a job to transfer a single table every night sounds like a great candidate for a cron job (or "scheduled task" if on Windows). Using a framework like Quartz for this task seems like overkill.

There are many solutions for moving data from SQL Server to MySQL, others have listed great solutions such as Talend. If it would benefit you to only transfer certain columns (for example, to avoid leaking PII), my product SQLpipe might help, as it transfers the result of a query, not an entire table.

Here is a blog post showing how to use the product to transfer data from SQL Server to MySQL.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 anjon
Solution 2 Community
Solution 3 Laabidi Raissi
Solution 4 SQLpipe

Related Questions