How to Sync Data from Mssql server to mysql

Question

Hi 

we have 1 table in mssql server db which need to be synced with mysql db.

how to achieve this ?

Regards,

Prabhu 

Answer 1

What I understood is you need to move the data from mySQL to msSQL table, if so . You need to have one SSIS package which will contain one Data flow task. 

Take mySQL table in the source and msSQL table in destination. Identify a column in mySQL table which will be used for delta load i.e. for the load of data that will change in upcoming runs like Last_update_date timestamp.

Let me know if this help you or not.

 

---

Please mark the post as answered if it answers your question

Answer 2

Hi Prabhu,

I suggest you can create a linked server instance in SQL Server, pointing to the MySQL instance. This article gives the step-by-step process: http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Please feel free to ask if you have any question.

Thanks,
Eileen

Answer 3

You can use the ODBC connection to the MySQL database in an ADO.NET connection manager.
That way you can use a traditional dataflow instead of using a linked server.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

Seems to me everyone answered your question as mysql > mssql.

Your question is mssql > mysql. Correct.

did you ever find someone, something to answer? I am stuggling for an way my self.

Answer 5

Seems to me everyone answered your question as mysql > mssql.

Your question is mssql > mysql. Correct.

did you ever find someone, something to answer? I am stuggling for an way my self.

My answer was for both ways: create an ODBC connection and use ADO.NET source/destination.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 6

The link mentioned by @Eileen above seems to be broken now. The following link should be of help - it was quite useful to me: https://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/