How to write a command in MySQL that will work on a table present in SqlServer?

Posted by Tripati_tutu under Sql Server on 2/15/2011 | Points: 10 | Views : 2839 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I have one table called "Employee" in MS-SQL. So I want to use that one in my MySQL database.
That is I want to write a update command in MySQL and it will do the operation on Employee table that is present in MS-SQL.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Madhu.b.rokkam on: 2/15/2011 [Member] [MVP] Bronze | Points: 25

0	I remember we have something called Linked Views in MySQL. You can use those Views to update the MSSQL tables. I have never done that offcourse. Check it once.. Thanks and Regards Madhu Tripati_tutu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 2/15/2011 [Member] [MVP] Bronze | Points: 25

0	Hi Madhu, Can you please provide some examples? Thanks Tripati_tutu, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Karthikanbarasan on: 2/15/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

0	Hi, You need to do the linked server concept from MySql to MsSql... Then using that you need to write a view to make the update!!!! Thanks Karthik www.f5Debug.net Tripati_tutu, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts