venk_r
asked on
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.
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.
ASKER
Actually I need to do update action too
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
right click db, export data and follow the steps...