Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 how to communicate from MS SQL Server to MySQL

Author  Topic 

rajak_dinesh
Starting Member

1 Post

Posted - 2007-12-21 : 05:00:58
I want to send table values from MS SQL Server to MySQL. For example if any row is inserted or deleted or updated in MS SQL Server database then the same has to be reflected in a similar table in MySQL so that the both the database table are in synch with each other. it would be of gr8 help if anyone could suggest something regarding this. Thanks in advance....

dinesh

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-21 : 05:06:09
Setting up replication between SQL Server database and MySQL database is one way.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-12-21 : 08:17:37
moved from script library.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-21 : 13:41:46
Or use trigger to update MySql db via linked server.
Go to Top of Page
   

- Advertisement -