locked
Execute an MSSQL Stored Procedure against a MYSQL database RRS feed

  • Question

  • User-1672578 posted

    Execute an MSSQL Stored Procedure against a MYSQL database


    I have an MSSQL database that must get selected fields from MYSQL database and insert them on my sql database.

    I have created a linked server and can perform simple queries against the MYSQL database but I am not sure how to run an MSSQL stored procedure against the MYSQL database. i'm thinking of having insert trigger on my MySQL table to call a procedure on MS SQL that will select and insert the field i want.
    Can anyone help?

    Wednesday, July 15, 2015 2:01 AM

All replies