Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sync  MYSQL with Sql server  data

Posted on 2011-09-04
4
Medium Priority
?
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 60

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 60

Accepted Solution

by:
HainKurt earned 1000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

636 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