How to trigger table Values from MySql to Sql server ?

Question

Hi  I did some table entries in My sql Table  While entry time  need to log entry in sql server Plz any one help with example codes

Manish Kumar · Answer

Hi Anish As per mineYou have to make linked server for connecting mysql to sql server. After creation of link server you have to create one job that will pull data from linked server to your sql server table. Check out the below link for connecting linked server with MySql. http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx Thanks Manish

Vignesh Mani · Answer

http://www.tech-recipes.com/rx/41414/sql-server-coding-the-after-insert-trigger-in-sql-server/