Hi all,

I am using MSSQL as a middleware server and MySQL as Enterprise Server.I established linked server from MSSQL to MySQL and i written triggers on MSSQL tables to access MySQl tables.Thats working fine.But,i have to make similar arrangement between MySQL to MSSQl and I have to write triggers on MySQL tables to update in MSSQL tables.Can any one suggests how to do these setup.

Thanks,
Ayyappa

You can use triggers in MSSQL to connect to a MySQL database and execute SQL..... COOOOOOOOOOOL!

Hi aschk,

Thanks for the reply,What you said is correct and it is working fine.But i want to use MySQL to SQL [not SQL to MySQL].I want to triggers in MySQL and that triggers should connect to SQL Server and do the modifications

Thanks,
Ayyappa