How can i update the Table which is in remote server

[Madhavi]

Hai every one
I want to update a table from one server to another server.
in my Location i am having a server Name : PROD84
and there is another server in Chicago Server Name: Dev34
i am working on PROD84 Server, i mapped Linked Server DEV34 then i am able to see the Table EMP
In my server STU table the columns (id,name, city,sal )
i want to update the records in DEV34 server Table EMP , the EMP also having same Columns (id,name,city,sal)
when ever i a record updates in EMP then i have toupdate the same details in DEV34 with the same values, how can i do , if any one give some help on this one. How can i do this one
I need help in this urgent..

thanks for your help..
Madhavi Soma

[zak]

try DTS

------------
Madhavi at 1/30/2002 8:35:06 PM

Hai every one
I want to update a table from one server to another server.
in my Location i am having a server Name : PROD84
and there is another server in Chicago Server Name: Dev34
i am working on PROD84 Server, i mapped Linked Server DEV34 then i am able to see the Table EMP
In my server STU table the columns (id,name, city,sal )
i want to update the records in DEV34 server Table EMP , the EMP also having same Columns (id,name,city,sal)
when ever i a record updates in EMP then i have toupdate the same details in DEV34 with the same values, how can i do , if any one give some help on this one. How can i do this one
I need help in this urgent..

thanks for your help..
Madhavi Soma

------------
Madhavi at 1/30/2002 8:35:06 PM

Hai every one
I want to update a table from one server to another server.
in my Location i am having a server Name : PROD84
and there is another server in Chicago Server Name: Dev34
i am working on PROD84 Server, i mapped Linked Server DEV34 then i am able to see the Table EMP
In my server STU table the columns (id,name, city,sal )
i want to update the records in DEV34 server Table EMP , the EMP also having same Columns (id,name,city,sal)
when ever i a record updates in EMP then i have toupdate the same details in DEV34 with the same values, how can i do , if any one give some help on this one. How can i do this one
I need help in this urgent..

thanks for your help..
Madhavi Soma

[Venu]

Hi there,

I Guess, You can use triggers to update the Table on DEV34 Server.
Write a trigger on u're PROD84 Server on EMP Table .... whenever there are any changes on that you update the same values on DEV434 Server.

-Venu


------------
at 4/27/2002 2:27:32 AM




------------
Madhavi at 1/30/2002 8:35:06 PM

Hai every one
I want to update a table from one server to another server.
in my Location i am having a server Name : PROD84
and there is another server in Chicago Server Name: Dev34
i am working on PROD84 Server, i mapped Linked Server DEV34 then i am able to see the Table EMP
In my server STU table the columns (id,name, city,sal )
i want to update the records in DEV34 server Table EMP , the EMP also having same Columns (id,name,city,sal)
when ever i a record updates in EMP then i have toupdate the same details in DEV34 with the same values, how can i do , if any one give some help on this one. How can i do this one
I need help in this urgent..

thanks for your help..
Madhavi Soma