Sync MYSQL with Sql server data

I m attempting to sync MYSQL with SQL Server data with no luck.
I tried SSIS solution but couldnt insert data into MYSQL (incorrect syntax)
Is there any other way or any aother tool ypu suggest.
My requirement:
I have a view in SQL Server (combination of 3 tables) which I want to sync to a mysql table which is sitting on a linus box.
I need to either insert or update data.
Who is Participating?
HainKurtConnect With a Mentor Sr. System AnalystCommented:
you can export into a temp table
the write a merge query
if mysql does not support merge query, then write one insert and one update query to update your target table in mysql
HainKurtSr. System AnalystCommented:
did you try to export data option from SSMS?
right click db, export data and follow the steps...
venk_rAuthor Commented:
Actually I need to do update action too
venk_rAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.