创建用于连接MS SQL和MySQL数据库的API

I am trying to connect MS SQL and MySQL databases. I tried to use Linked server...It creates an instance of MySQL databases in MS SQL. But what I need is a separate table from a database should connect both the servers. I was using PHP to insert record to MySQL when I insert in MySQL. It should be automatically insert in to MS SQL Server.

Please try to give some ideas...or any other better way.

You can use trigger for this.

You must create a trigger inside of MYSQL. when a record added to MYSQL database, automatically add this row to the MSSQL.