MySQL Forums
Forum List  »  Connector/ODBC

Execute an MSSQL Stored Procedure against a MYSQL database
Posted by: mokwena kgwete
Date: July 14, 2015 11:54PM

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?

Options: ReplyQuote


Subject
Written By
Posted
Execute an MSSQL Stored Procedure against a MYSQL database
July 14, 2015 11:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.