Update Table Query from one server to another

[Syedsql]

Hi,

I have two servers like A and B. Both A and B have same table.Now i want to update the table from A server with table from B server data. IS it possible??

[ck9663]

Yes it's possible.

You can either create a code or do a replication.

Good Luck!!!


~~ CK

[Maraj]

you can write a query like this
I am supposing you are running this on Server A.

begin tran
update Table 
set column=somevalue
where value=(select value from serverB.DataBasename.dbo.table where value=somevalue)

This will update value from Server B to Server A

[Rabbit]

That will only work is the server is set up as a linked server and only if you have the permissions to. At our work, we are not allowed to do this.

[ck9663]

And be careful with that syntax, that's an RBAR.

Good Luck!!!


~~ CK

[Sri Ganesh]

Hi
Use this Query,

UPDATE SERVER1TABLE SET SERVER1TABLE.COLUMN1=B.COLUMN1,SERVER1TABLE.COLUMN2=B.COLUMN2
FROM OPENDATASOURCE('SQLNCLI','DATA SOURCE=SECONDSERVERNAME;UID=XXXX;PWD=XXXXX').DATABASENAME.DBO.SERVER2TABLE AS B
WHERE B.COLUMN1='XXXX' AND HRMS10EMPLOYEE.COLUMN1='XXXX'

Regards,
Sri Ganesh