-
How can i update the Table which is in remote server
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
-
How can i update the Table which is in remote server (reply)
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
-
How can i update the Table which is in remote server (reply)
------------
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
-
How can i update the Table which is in remote server (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|