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 : 1767 | Status : [Member] | Replies : 3
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.




Responses

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

Up
0
Down
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

Up
0
Down
Hi Madhu,

Can you please provide some examples?

Thanks

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

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

Up
0
Down
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

Login to post response