sycn data between two sql server in wan

See more:

VB

hi all,

i have same database with tow diffrent server in WAN environment, if any changes happnd one database sample_table,i want to sycn that sample_table data's to other database,

i am using except kyeword to find diffence between two tables,but its taking too long time to excute.also my table has huge data

this is my query

select * from server_1.db_name.sample_table
except
select * from server_2.db_name.sample_table