Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    4

    Unanswered: triggers and linked serevrs in MySQL

    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

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    You can use triggers in MSSQL to connect to a MySQL database and execute SQL..... COOOOOOOOOOOL!

  3. #3
    Join Date
    Apr 2007
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •