Solved

Sync  MYSQL with Sql server  data

Posted on 2011-09-04
4
250 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:venk_r
  • 2
  • 2
4 Comments
 
LVL 51

Expert Comment

by:HainKurt
ID: 36481808
did you try to export data option from SSMS?
right click db, export data and follow the steps...
0
 
LVL 8

Author Comment

by:venk_r
ID: 36481840
Actually I need to do update action too
0
 
LVL 51

Accepted Solution

by:
HainKurt earned 500 total points
ID: 36481863
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
0
 
LVL 8

Author Closing Comment

by:venk_r
ID: 36561984
Thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question