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.