Loading

How to trigger table Values from MySql to Sql server ?

Anish Kumar

9y979

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar9y ago
Hi Anish,

As per mine,You 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
0
Vignesh Mani9y ago
http://www.tech-recipes.com/rx/41414/sql-server-coding-the-after-insert-trigger-in-sql-server/
0