0

I have two databases

  1. MS SQL Server (with the table t1)
  2. MySQL Server (with the table t2)

I want to insert the data into table t2 on MySQL Server when some data inserted into table t1 on MS SQL Server.

I have already tried to create the linked server and use the trigger but it is not working.

How can I do that?

lorond
  • 3,856
  • 2
  • 37
  • 52
yoosuf
  • 29
  • 3
  • Maybe these links can help you : http://stackoverflow.com/questions/14874587/replicate-microsoft-sql-to-other-databases http://fr.slideshare.net/thetaung/sql-server-replication-transactional-replication-from-mssql-200x-to-mysql-5x – liotims Aug 26 '16 at 07:06
  • Show your trigger code – StackUser Aug 26 '16 at 08:03
  • Possible duplicate of [Convert T-SQL to MySQL](http://stackoverflow.com/questions/2986404/convert-t-sql-to-mysql) – Elijan9 Aug 26 '16 at 08:31
  • you can use replication MSSQL and myssql. http://stackoverflow.com/questions/5904447/replication-between-sql-server-and-mysql-server – Vishe Nov 06 '16 at 01:35

0 Answers0